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
I spoke with Adobe Support over the phone and the only answer I could get was Illustrator must be run under an admin account. For those who may be interested in helping figure this one out: This is installed on an enterprise network, therefor handing [More]
Hi, I'm studying the following code: public static char[] byteToHex(byte[] data) {   char[] retValue = new char[data.length * 2];   int value = 0;   int highIndex = 0;   int lowIndex = 0;   for (int i = 0; i < retValue.length; i++) {     value = (dat [More]
hi when I turn my pavilion dv6 2170ee computer on screen shows below error. system diognostics (F2) does not any work and when my windows7 comming up this error was shown. I install Hard Disk Sentinel software and this program shows below: Failure Pr [More]
Dear all, I am using SAP Best Practices pre-configured scenario for Services Industries. Generally, this is to address the need of customer's need for fixed price and time & material billing in a standard service industry practice, which the flow of [More]
Hi, I have a ALV report. I want color in my report like Column Wise. ex. Document No........Date.........Amount......Document No......Date........Amount........Document Nov........Date.............Amount.... 2008000123...10.07.2009....2000.00......20 [More]
I think I've seen this before  in these pages, but I can't find it now I really need it. Using CS3 on a Mac 10.4.11 I have two Photoshop documents of same size and resolution. I want to copy an item from one document into the same place in the other [More]
hi I'm newbie to jsp and i want to know is there any familiar thing like a function? i developed some sites before in asp and php ...... and now i'm learning jsp.... what is the best thing in jsp to use if you have the same actions to do a lot of tim [More]
I just transferred to my moms old iPhone. I made a new Apple ID but when info to apps I cannot get them due to the fact that my moms credit cards is being declinedare there funds on the card? because iTunes isn't the one declining the card, its the b [More]
In VMware, I am getting error message about enabling Intel VT-x setting in bios ? I have no idea how to go to BIOS in windows 8 and how to enable it ? Could you please guide me how to enable VT-x in windows 8 ?Hi, As enabling Intel VT-x is related to [More]
Hi Expert, I have a requirement in which we do not need APPEND/INSERT/DELETE button in ALV,Can you please tell how i can remove that. Pleaae suggest. Thanks MaheshCheck this     data lo_cmp_usage type ref to if_wd_component_usage.     lo_cmp_usage =  [More]