DBA Data[Home] [Help]

APPS.INV_MO_PURGE dependencies on WSH_DELIVERY_DETAILS

Line 92: FROM wsh_delivery_details wsd

88: oel_exists := 'Y'; -- Added for bug # 6469970
89: BEGIN
90: SELECT 1
91: INTO can_delete
92: FROM wsh_delivery_details wsd
93: WHERE wsd.move_order_line_id = mo_line.line_id
94: AND wsd.inv_interfaced_flag = 'Y'
95: AND ROWNUM < 2;
96:

Line 123: FROM wsh_delivery_details wdd

119: WHERE oola.line_id = mo_line.txn_source_line_id
120: AND ( (NVL(open_flag, 'Y') = 'N') OR cancelled_flag = 'Y')
121: AND NOT EXISTS (
122: SELECT 1
123: FROM wsh_delivery_details wdd
124: WHERE wdd.source_line_id = oola.line_id
125: AND wdd.inv_interfaced_flag IN ('N', 'P')
126: AND wdd.released_status <> 'D')
127: AND ROWNUM =1;

Line 156: FROM wsh_delivery_details wdd

152: FROM mtl_material_transactions_temp mmtt
153: WHERE mmtt.move_order_line_id = mo_line.line_id)
154: AND NOT EXISTS (
155: SELECT 1
156: FROM wsh_delivery_details wdd
157: WHERE wdd.source_line_id = oola.line_id
158: AND wdd.source_code = 'OE'
159: AND wdd.move_order_line_id = mo_line.line_id)
160: AND ROWNUM = 1;

Line 171: FROM wsh_delivery_details wdd

167: -- Start of Bug #6469970
168: IF (can_delete = 0) THEN
169: BEGIN
170: SELECT distinct wdd.inv_interfaced_flag into inv_int_flag
171: FROM wsh_delivery_details wdd
172: WHERE wdd.move_order_line_id = mo_line.line_id;
173:
174: IF inv_int_flag = 'Y' THEN
175: can_delete := 1;