APPS.AHL_OSP_ACCOMP_PVT dependencies on OE_ORDER_LINES_ALL

Line 461: FROM AHL_OSP_ORDER_LINES OSPL, OE_ORDER_LINES_ALL OEL

457: l_accomplishment_dtls get_accomplishment_dtls_csr%ROWTYPE;
458:
459: CURSOR get_received_quantity_csr(c_osp_order_line_id IN NUMBER) IS
460: SELECT OEL.shipped_quantity
461: FROM AHL_OSP_ORDER_LINES OSPL, OE_ORDER_LINES_ALL OEL
462: WHERE OSPL.OSP_ORDER_LINE_ID = c_osp_order_line_id
463: AND OEL.line_id = OSPL.OE_RETURN_LINE_ID;
464:
465: CURSOR get_descendant_UEs_csr (c_ue_id IN NUMBER) IS

Line 763: FROM AHL_OSP_ORDER_LINES OSPL, OE_ORDER_LINES_ALL OEL

759: WHERE osp_order_line_id = p_osp_order_line_id;
760:
761: CURSOR get_received_quantity_csr IS
762: SELECT OEL.shipped_quantity
763: FROM AHL_OSP_ORDER_LINES OSPL, OE_ORDER_LINES_ALL OEL
764: WHERE OSPL.OSP_ORDER_LINE_ID = p_osp_order_line_id
765: AND OEL.line_id = OSPL.OE_RETURN_LINE_ID;
766:
767: CURSOR get_received_instance_csr IS

Line 774: AND tl.source_transaction_table = 'OE_ORDER_LINES_ALL'

770: csi_t_txn_line_details tld,
771: ahl_osp_order_lines ospl
772: WHERE ospl.osp_order_line_id = p_osp_order_line_id
773: AND tl.source_transaction_id = ospl.oe_return_line_id
774: AND tl.source_transaction_table = 'OE_ORDER_LINES_ALL'
775: AND tld.transaction_line_id = tl.transaction_line_id;
776:
777: CURSOR get_instance_descendants_csr (c_instance_id NUMBER) IS
778: SELECT c_instance_id from DUAL

Line 809: l_oe_line_id OE_ORDER_LINES_ALL.line_id%TYPE;

805: l_curr_inst_id NUMBER;
806: l_found_flag BOOLEAN;
807:
808: oe_header_id AHL_OSP_ORDERS_B.oe_header_id%TYPE;
809: l_oe_line_id OE_ORDER_LINES_ALL.line_id%TYPE;
810: l_dummy VARCHAR2(1);
811: --
812:
813: BEGIN