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 65: from wsh_delivery_details

61: */
62:
63: cursor line_id is
64: select source_line_id
65: from wsh_delivery_details
66: where delivery_detail_id =pr_new.ref_line_id;
67:
68: cursor customer is
69: select bill_to_customer_id

Line 204: FROM wsh_delivery_details

200:
201:
202: CURSOR so_picking_hdr_cur IS
203: SELECT source_header_id, delivery_detail_id
204: FROM wsh_delivery_details
205: WHERE delivery_detail_id = pr_new.ref_line_id;
206:
207: -- Altered by Arun for 11i.
208: CURSOR Org_warehouse_cur(p_picking_header_id NUMBER) IS

Line 210: FROM wsh_delivery_details

206:
207: -- Altered by Arun for 11i.
208: CURSOR Org_warehouse_cur(p_picking_header_id NUMBER) IS
209: SELECT NVL(org_id,0), ORGANIZATION_ID
210: FROM wsh_delivery_details
211: WHERE delivery_detail_id = p_picking_header_id;
212:
213: CURSOR get_conv_detail_cur(p_order_header_id Number) IS
214: SELECT TRANSACTIONAL_CURR_CODE, conversion_type_code, conversion_rate,

Line 226: from wsh_delivery_details

222: */
223:
224: -- Altered by Arun for 11i
225: cursor line is select source_line_id
226: from wsh_delivery_details
227: where delivery_detail_id =pr_new.ref_line_id;
228:
229: -- Altered by Arun for 11i
230: cursor customer is

Line 234: from wsh_delivery_details

230: cursor customer is
231: select SOLD_TO_ORG_ID
232: from oe_order_headers_all
233: where header_id in (select source_header_id
234: from wsh_delivery_details
235: where delivery_detail_id =pr_new.ref_line_id );
236:
237:
238: BEGIN