Sitemap

Amicuk Programming Answers

Price list line = orderline?

-0001-11-30   Views:0

Advertisement

An order line in oe_order_lines_all stores the price list id but not the list line id. List Id + Product Id is also not unique. How do I get the list line id for a particular order line??Hi, even with the start date, end date combination a list line

An order line in oe_order_lines_all stores the price list id but not the list line id.
List Id + Product Id is also not unique.
How do I get the list line id for a particular order line??

The replay answer
Advertisement
Hi,
even with the start date, end date combination a list line is not unique.Two different list lines can exist for the same item, same effective period but with different pricing attribute and pricing attribute values.
so how do i trace the exact price list line from the order_lines table.??

Go to See the other 5 answers

Price list line = orderline?

Category:DefaultRelease time:-0001-11-30Views:130

An order line in oe_order_lines_all stores the price list id but not the list line id. List Id + Product Id is also not unique. How do I get the list line id for a particular order line??Hi, even with the start date, end date combination a list line[More]

Purchase price variance line item - not to be posted in Parallel currency

Category:DefaultRelease time:2015-10-11Views:130

Hi All, Scenario: Transaction currency - SGD Local Currency - INR Parallel Currency 1 (LC2) - Group currency - USD Parallel Currency 2 (LC3) - Global Company currency - INR Import PO - MIGO - MIRO PO is raised in foreign currency. Material master pri[More]

Enter Text in Price difference line item in MIRO

Category:DefaultRelease time:2015-10-11Views:130

Hello, My user wants to enter text in price difference account line item in MIRO. I tried to do it in MIRO simulation by doubl click on line item. But it does not show as we normally see in FI documents. Please advise how can I enter text in price di[More]

No Price List Line Item in Price List detail page

Category:DefaultRelease time:2015-10-11Views:130

Hi I just started with Oracle ON Demand so my question my look silly but I couldn't find solution myself and I have to ask. When I created Price List and Product now it is time to connect one to another. But, when I went into Price List list page, cl[More]

How to add new price break lines to existing PO quotations?

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I am using a custom interface (to insert quotations data into PO headers/lines interface tables) and PO documents open interface to create PO Quotations in Oracle. I need to modify this interface to: 1. Update existing price break lines for a quo[More]

How to get price list line id for service contract line(subline)

Category:DefaultRelease time:-0001-11-30Views:130

Does some one know how to find a price list line id for service contracts line (sub line)? There is actually a column in table okc_k_lines_b which is called price_list_line_id, but it looks like it is never used (all columns values are NULL). I have[More]

PRICE LIST LINE을 DELETE 하는 SAMPLE API

Category:DefaultRelease time:-0001-11-30Views:130

제품 : MFG_QP 작성날짜 : 2006-05-23 PRICE LIST LINE을 DELETE 하는 SAMPLE API ======================================== PURPOSE Price List Lines을 delete 할 수 있는 API가 있는지 알아보고 그 사용방법 을 이해한다. Explanation 아래 설명하는 script는 Price List Lines 만을 delete 하는 sample API scr[More]

Price List Lines doesn't shown up

Category:DefaultRelease time:-0001-11-30Views:130

All of sudden the price list lines are doesn't shown up on the price list form, any idea? Srini CCan't tell what could have happened, but check the qp_pricing_attributes table for the qualification_id flag. It should be 4. If it is not run QP: Mainta[More]

R12: Disable Field Quantity and Unit Price in Line Item (AR)

Category:DefaultRelease time:2015-10-11Views:130

Hello, Is there a setup in Oracle Receivables - Transactions where I can disable the field "Quantity" and "Unit Price" on the form for line item? I don't have Order Management nor Inventory setup in this environment. Note: In AP invoic[More]

Purchase Contract Price on line item

Category:DefaultRelease time:2015-10-11Views:130

Scenario Purchase contract line item has conditions defined with multiple validity periods and scales for the price. When one uses transaction ME33K one sees the net price applicable on the current date. and this is not what is stored in the EKPO-NET[More]

Copy Quote discount price with 'line item proposal' in VA01

Category:DefaultRelease time:2015-10-11Views:130

Hi Expert Does anyone know how we can use 'line item proposal' to copy discount prices from Quotation into Sales Order via VA01? We want to copy all line items from a previous quote into new sales order, in our test all line item details was copied a[More]

Hot
Dear all, seek for your help for the following issue There is a A/R invoice with 3 items There is a report for retrieving the line item level data from inv1, user would also like to add a column to display the Document total , but the problem is, eac [More]
Please help ! I have just created a small movie in iMovie '09 from imported clips from Sony Handycam with miniDV tapes. All clips imported easily and can be viewed and edited. Though when I try to share the project to iTunes or even export it to my d [More]
I'm working on a Medical instruction manual that was done in Microsoft Word.    The TOC came over and SEEMs to link up to it's appropriate areas but I'm having a hard double checking because of the naming conventions (i.e. "ref00084848").   I wa [More]
i am using informix database which accepts date value in the form of DATE format...... the other part of my application takes date from the field in DD/MM/YYYY format...so i have to convert my java.sql.date in YYYY/MM/DD fromat into DD/MM/YYYY fromat [More]
I have my machine reimaged, now when I try to preview an rtf template I get the below error. Nothing has changed in my template and I am using 1.0.0 Build 9 as before my reimage as well. This is an uregent problem that I am not able to find the solut [More]
Hi All, can you please help me in tiggering an action. the below code is posted by jonas and in debugging i found that it is working fine but it is not saving.if it is saved then the issue is solved.pls can anyone help me. Is there any FM or Class to [More]
Can a task sequence setup for collection variables be used with different collections [each with different collection variables] and each having a unique deployment? RegardsYou are free to file feedback on connect.microsoft.com but first think about [More]
Hi, I don't know why this is so difficult but I just want to do the most basic thing. In photos view, I want to create a roll (new category of pictures). Then I want to move photos from one roll to another. I can drag them up or down but I will move [More]
Hi All I have senario  IDOC - HTTP  the flow will be like this IDOC - HTTP - HTTPRESPONSE - IDOC AUDIT I  have planned to use BPM but the problem is when Creating Message interface i cannot make  idoc as sych so please tell me how may MI and IM will [More]