DBA Data[Home] [Help]

APPS.CTO_TRANSFER_PRICE_PK dependencies on OE_ORDER_LINES_ALL

Line 93: from oe_order_lines_all oel

89: into l_line_id
90: from bom_cto_order_lines bcol
91: where config_item_id = p_item_id
92: and exists (select 'x'
93: from oe_order_lines_all oel
94: where oel.header_id = bcol.header_id
95: and oel.ato_line_id = bcol.ato_line_id
96: and oel.item_type_code = 'CONFIG')
97: and rownum = 1;

Line 223: from oe_order_lines_all oel

219: into l_line_id
220: from bom_cto_order_lines bcol
221: where config_item_id = p_item_id
222: and exists (select 'x'
223: from oe_order_lines_all oel
224: where oel.header_id = bcol.header_id
225: and oel.ato_line_id = bcol.ato_line_id
226: and oel.item_type_code = 'CONFIG')
227: and rownum = 1;

Line 421: from oe_order_lines_all

417:
418: l_oeval_org_id number;
419: cursor get_oeval_org_id is
420: select to_number( nvl( oe_sys_parameters.value( 'MASTER_ORGANIZATION_ID' , org_id) , ship_from_org_id))
421: from oe_order_lines_all
422: where line_id = p_line_id;
423:
424: BEGIN
425: