DBA Data[Home] [Help]

APPS.CS_CSXSVODS_CHECK_PKG dependencies on SO_LINES

Line 48: from so_lines_interface

44: p_customer_product_id NUMBER) IS
45:
46: CURSOR check_duplicate IS
47: select 'Y'
48: from so_lines_interface
49: where inventory_item_id+0 = p_inventory_item_id
50: AND customer_product_id = p_customer_product_id;
51:
52: BEGIN

Line 72: from so_lines sol,

68:
69:
70: CURSOR check_duplicate IS
71: select 'Y'
72: from so_lines sol,
73: so_headers soh
74: where inventory_item_id+0 = p_inventory_item_id
75: AND customer_product_id = p_customer_product_id
76: AND nvl(soh.cancelled_flag,'N') = 'N'