APPS.RCV_TRANSACTION_SV dependencies on OE_ORDER_LINES_ALL

Line 286: from oe_order_lines_all

282: -- Bug 3378162: for rma receipts, default subinventory from oe line.
283: elsif x_oe_order_line_id is not null then
284: select subinventory
285: into x_subinventory
286: from oe_order_lines_all
287: where line_id = x_oe_order_line_id;
288: end if;
289:
290: IF x_subinventory is null then

Line 692: FROM oe_order_lines_all

688: IF (x_oe_order_line_id IS NOT NULL) THEN
689:
690: SELECT project_id, task_id
691: INTO X_project_id,X_task_id
692: FROM oe_order_lines_all
693: WHERE line_id = x_oe_order_line_id;
694:
695: IF ( X_project_id IS NOT NULL AND
696: X_task_id IS NOT NULL ) THEN

Line 824: from oe_order_lines_all

820: select haou.location_id
821: into l_deliver_to_location_id
822: from hr_all_organization_units haou
823: where haou.organization_id = (select ship_from_org_id
824: from oe_order_lines_all
825: where line_id = x_oe_order_line_id);
826:
827: end if;
828: elsif x_destination_type_code = 'RECEIVING' then

Line 950: FROM oe_order_lines_all

946: x_locator_id IS NOT NULL) THEN
947:
948: SELECT project_id, task_id
949: INTO X_project_id,X_task_id
950: FROM oe_order_lines_all
951: WHERE line_id = x_oe_order_line_id;
952:
953: END IF;
954:

Line 1334: FROM oe_order_lines_all

1330: x_locator_id IS NOT NULL) THEN
1331:
1332: SELECT project_id, task_id
1333: INTO X_project_id,X_task_id
1334: FROM oe_order_lines_all
1335: WHERE line_id = x_oe_order_line_id;
1336:
1337: END IF;
1338: