eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_ADV_PRICE_PVT dependencies on OE_ORDER_LINES

Line 1289: l_tot_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE;

1285: )
1286: IS
1287: l_line_rec Oe_Order_Pub.line_rec_type := px_line_rec;
1288: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
1289: l_tot_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE;
1290: l_tot_price_qty OE_ORDER_LINES_ALL.pricing_quantity%TYPE;
1291: l_pricing_event varchar2(30);
1292: l_return_status varchar2(1);
1293: --

Line 1290: l_tot_price_qty OE_ORDER_LINES_ALL.pricing_quantity%TYPE;

1286: IS
1287: l_line_rec Oe_Order_Pub.line_rec_type := px_line_rec;
1288: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
1289: l_tot_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE;
1290: l_tot_price_qty OE_ORDER_LINES_ALL.pricing_quantity%TYPE;
1291: l_pricing_event varchar2(30);
1292: l_return_status varchar2(1);
1293: --
1294: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1340: from oe_order_lines

1336: IF (l_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
1337: begin
1338: select nvl(sum(ordered_quantity),0),nvl(sum(pricing_quantity),0)
1339: into l_tot_qty,l_tot_price_qty
1340: from oe_order_lines
1341: where split_from_line_id = l_line_rec.line_id
1342: and header_id = l_line_rec.header_id;
1343: exception
1344: when others then

Line 1654: l_tot_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE ;

1650: E_CLOSED_LINE Exception;
1651: --
1652: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1653: --
1654: l_tot_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE ;
1655: l_tot_price_qty OE_ORDER_LINES_ALL.pricing_quantity%TYPE ;
1656: l_ordered_quantity OE_ORDER_LINES_ALL.ordered_quantity%TYPE;
1657: l_pricing_quantity OE_ORDER_LINES_ALL.pricing_quantity%TYPE;
1658: l_mod_line_id NUMBER;

Line 1655: l_tot_price_qty OE_ORDER_LINES_ALL.pricing_quantity%TYPE ;

1651: --
1652: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1653: --
1654: l_tot_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE ;
1655: l_tot_price_qty OE_ORDER_LINES_ALL.pricing_quantity%TYPE ;
1656: l_ordered_quantity OE_ORDER_LINES_ALL.ordered_quantity%TYPE;
1657: l_pricing_quantity OE_ORDER_LINES_ALL.pricing_quantity%TYPE;
1658: l_mod_line_id NUMBER;
1659:

Line 1656: l_ordered_quantity OE_ORDER_LINES_ALL.ordered_quantity%TYPE;

1652: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1653: --
1654: l_tot_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE ;
1655: l_tot_price_qty OE_ORDER_LINES_ALL.pricing_quantity%TYPE ;
1656: l_ordered_quantity OE_ORDER_LINES_ALL.ordered_quantity%TYPE;
1657: l_pricing_quantity OE_ORDER_LINES_ALL.pricing_quantity%TYPE;
1658: l_mod_line_id NUMBER;
1659:
1660: --service er variable declarion start 16227925

Line 1657: l_pricing_quantity OE_ORDER_LINES_ALL.pricing_quantity%TYPE;

1653: --
1654: l_tot_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE ;
1655: l_tot_price_qty OE_ORDER_LINES_ALL.pricing_quantity%TYPE ;
1656: l_ordered_quantity OE_ORDER_LINES_ALL.ordered_quantity%TYPE;
1657: l_pricing_quantity OE_ORDER_LINES_ALL.pricing_quantity%TYPE;
1658: l_mod_line_id NUMBER;
1659:
1660: --service er variable declarion start 16227925
1661: l_inventory_item_id NUMBER;

Line 1703: from oe_order_lines

1699:
1700: begin
1701: select nvl(sum(ordered_quantity + nvl(cancelled_quantity,0)),0),nvl(sum(pricing_quantity + nvl(cancelled_quantity,0)),0)
1702: into l_tot_qty,l_tot_price_qty
1703: from oe_order_lines
1704: where split_from_line_id = l_line_rec.line_id
1705: and header_id = l_line_rec.header_id;
1706: exception
1707: when others then

Line 2158: from oe_order_lines_all

2154: into l_order_source_id, l_orig_sys_document_ref,
2155: l_orig_sys_line_ref, l_orig_sys_shipment_ref,
2156: l_change_sequence, l_source_document_type_id,
2157: l_source_document_id, l_source_document_line_id
2158: from oe_order_lines_all
2159: where line_id = l_line_id;
2160: EXCEPTION
2161: WHEN NO_DATA_FOUND THEN
2162: IF l_debug_level > 0 THEN

Line 2554: ,OE_ORDER_LINES l

2550: lines.PRICE_LIST_HEADER_ID,
2551: l.price_list_id
2552: FROM
2553: QP_PREQ_LINES_TMP lines
2554: ,OE_ORDER_LINES l
2555: WHERE lines.pricing_status_code IN
2556: ( QP_PREQ_GRP.G_STATUS_UPDATED
2557: ,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
2558: AND lines.process_status <> 'NOT_VALID'