APPS.AHL_OSP_ACCOMP_PVT dependencies on AHL_OSP_ORDER_LINES

Line 437: FROM ahl_osp_order_lines

433: AND accomplished_date is not null;
434:
435: CURSOR chk_osp_line_csr(c_osp_order_line_id NUMBER) IS
436: SELECT 'X'
437: FROM ahl_osp_order_lines
438: WHERE osp_order_line_id = c_osp_order_line_id;
439:
440: CURSOR get_accomplishments_csr(c_osp_order_line_id NUMBER) IS
441: SELECT accomplishment_id

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 771: ahl_osp_order_lines ospl

767: CURSOR get_received_instance_csr IS
768: SELECT tld.instance_id
769: FROM csi_t_transaction_lines tl,
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;