APPS.JAI_JMCR_TRIGGER_PKG dependencies on WSH_DELIVERY_DETAILS

Line 43: FROM wsh_delivery_details

39:
40:
41: CURSOR so_picking_hdr_cur IS
42: SELECT source_header_id, delivery_detail_id
43: FROM wsh_delivery_details
44: WHERE delivery_detail_id = pr_new.ref_line_id;
45:
46: CURSOR Org_warehouse_cur(p_picking_header_id NUMBER) IS
47: SELECT NVL(org_id,0), ORGANIZATION_ID

Line 48: FROM wsh_delivery_details

44: WHERE delivery_detail_id = pr_new.ref_line_id;
45:
46: CURSOR Org_warehouse_cur(p_picking_header_id NUMBER) IS
47: SELECT NVL(org_id,0), ORGANIZATION_ID
48: FROM wsh_delivery_details
49: WHERE delivery_detail_id = p_picking_header_id;
50:
51: -- Altered by Arun for 11i
52:

Line 71: from wsh_delivery_details

67: AND organization_id = p_warehouse_id;
68:
69: cursor line_id is
70: select source_line_id
71: from wsh_delivery_details
72: where delivery_detail_id =pr_new.ref_line_id;
73:
74: cursor customer is
75: select bill_to_customer_id

Line 212: FROM wsh_delivery_details

208:
209:
210: CURSOR so_picking_hdr_cur IS
211: SELECT source_header_id, delivery_detail_id
212: FROM wsh_delivery_details
213: WHERE delivery_detail_id = pr_new.ref_line_id;
214:
215: -- Altered by Arun for 11i.
216: CURSOR Org_warehouse_cur(p_picking_header_id NUMBER) IS

Line 218: FROM wsh_delivery_details

214:
215: -- Altered by Arun for 11i.
216: CURSOR Org_warehouse_cur(p_picking_header_id NUMBER) IS
217: SELECT NVL(org_id,0), ORGANIZATION_ID
218: FROM wsh_delivery_details
219: WHERE delivery_detail_id = p_picking_header_id;
220:
221: CURSOR get_conv_detail_cur(p_order_header_id Number) IS
222: SELECT TRANSACTIONAL_CURR_CODE, conversion_type_code, conversion_rate,

Line 234: from wsh_delivery_details

230: */
231:
232: -- Altered by Arun for 11i
233: cursor line is select source_line_id
234: from wsh_delivery_details
235: where delivery_detail_id =pr_new.ref_line_id;
236:
237: -- Altered by Arun for 11i
238: cursor customer is

Line 242: from wsh_delivery_details

238: cursor customer is
239: select SOLD_TO_ORG_ID
240: from oe_order_headers_all
241: where header_id in (select source_header_id
242: from wsh_delivery_details
243: where delivery_detail_id =pr_new.ref_line_id );
244:
245: CURSOR set_of_books_cur(p_org_id NUMBER, p_warehouse_id NUMBER) IS
246: SELECT set_of_books_id