APPS.RCV_TRANSACTION_SV dependencies on OE_ORDER_LINES_ALL

Line 309: from oe_order_lines_all

305: -- Bug 3378162: for rma receipts, default subinventory from oe line.
306: elsif x_oe_order_line_id is not null then
307: select subinventory
308: into x_subinventory
309: from oe_order_lines_all
310: where line_id = x_oe_order_line_id;
311: end if;
312:
313: IF x_subinventory is null then

Line 719: FROM oe_order_lines_all

715: IF (x_oe_order_line_id IS NOT NULL) THEN
716:
717: SELECT project_id, task_id
718: INTO X_project_id,X_task_id
719: FROM oe_order_lines_all
720: WHERE line_id = x_oe_order_line_id;
721:
722: IF ( X_project_id IS NOT NULL AND
723: X_task_id IS NOT NULL ) THEN

Line 851: from oe_order_lines_all

847: select haou.location_id
848: into l_deliver_to_location_id
849: from hr_all_organization_units haou
850: where haou.organization_id = (select ship_from_org_id
851: from oe_order_lines_all
852: where line_id = x_oe_order_line_id);
853:
854: end if;
855: elsif x_destination_type_code = 'RECEIVING' then

Line 977: FROM oe_order_lines_all

973: x_locator_id IS NOT NULL) THEN
974:
975: SELECT project_id, task_id
976: INTO X_project_id,X_task_id
977: FROM oe_order_lines_all
978: WHERE line_id = x_oe_order_line_id;
979:
980: END IF;
981:

Line 1361: FROM oe_order_lines_all

1357: x_locator_id IS NOT NULL) THEN
1358:
1359: SELECT project_id, task_id
1360: INTO X_project_id,X_task_id
1361: FROM oe_order_lines_all
1362: WHERE line_id = x_oe_order_line_id;
1363:
1364: END IF;
1365: