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
When I click on my iTunes icon in the dock, iTunes won't open. Instead, a message box comes up: "The file iTunes "library" cannot be read because it was created by a newer version of iTunes." Just before this happened, I imported a lot [More]
I had posted this, but directd n wrong forum, 29-Mar-2014 04:34 Your ios 7 has broken my wifi connection on my ipad. I hve a brand new router 30hrs old. My ipad 2 is not jail broken, jst ios 7 broken! Turning my router on and off could possibly break [More]
A common keyboard shortcut is not working. When I want to resize an image and keep the dimensions as I resize the image box up or down, I usually click one of the image box corners, hold down shift + command, and the dimensions of the box, along with [More]
Hi there, I have a few questions regarding the Datalist function in FC 5.5. Is there a way to change the order of the items, rows in the Datalist? I would like to use a datalist to show viewers newsitems, so it would be nice if the newest post ("row& [More]
My Safari 6 browser keep crashing on startup. I am running Mac OS X 10.7.4. Here is the problem report log from Safari. Any help would be much appreciated. Thanks. Process:         Safari [464] Path:            /Applications/Safari.app/Contents/MacOS [More]
I am having a report consist of some numberic columns like Emplid (0011, 0223, 00045). When I do the export, these zero's are getting dropped in the csv file. so in csv file I am having 11, 223, 45 values How to avoid this??Hi, I tried with following [More]
Hi I need an example of the DTD and the xml file delivered by Oracle XML Gateway which i can present as an example for a customer. Does anybody knows where to find those or if someone coulld mail them to me ? [email protected] Thanks in advance /Drag [More]
So I've been suffering through iPhoto since it came out. I say "suffering" because it frequently crashes, behaves poorly, uses 95% of one CPU, and corrupts its library. Version after version, from 1 through 11, it's been having issues. It totall [More]
I installed oracle 11g and was attempting to do a data pump from the dev machine to my computer however when I run the impdp command I get an ORA-12560: TNS:protocol adapter error. A co-worker thought I might need to add a loopback adapter as that ha [More]
How do I get rid of the Mac Defender?I have installed it on many Macs and have not had any users report kernel panics or slowdowns because of it. "Any Mac on which those trojans is installed is being horrendously misused, and Sophos doesn't change th [More]