APPS.WMS_WIP_INTEGRATION dependencies on WIP_LPN_COMPLETIONS_SERIALS

Line 80: FROM wip_lpn_completions_serials

76: SELECT
77: header_id,
78: lot_number,
79: fm_serial_number
80: FROM wip_lpn_completions_serials
81: WHERE header_id = l_temp_header_id
82: AND lot_number is not null;
83:
84: CURSOR wip_lpn_comp_serials_csr2 IS

Line 86: FROM wip_lpn_completions_serials

82: AND lot_number is not null;
83:
84: CURSOR wip_lpn_comp_serials_csr2 IS
85: SELECT fm_serial_number
86: FROM wip_lpn_completions_serials
87: WHERE header_id = l_temp_header_id
88: AND lot_number IS NULL;
89:
90: /* Bug: 2976160 : cursor defined to replace 'Select INTO ' to support

Line 399: FROM wip_lpn_completions_serials

395: time_since_visit,
396: cycles_since_visit,
397: time_since_mark,
398: cycles_since_mark
399: FROM wip_lpn_completions_serials
400: WHERE header_id = l_temp_header_id
401: AND lot_number is null);
402:
403: IF (l_debug = 1) THEN

Line 809: FROM wip_lpn_completions_serials

805: time_since_visit,
806: cycles_since_visit,
807: time_since_mark,
808: cycles_since_mark
809: FROM wip_lpn_completions_serials
810: WHERE header_id = l_temp2_header_id
811: AND lot_number = l_lot_number);
812:
813: END LOOP;

Line 1045: FROM wip_lpn_completions_serials

1041: time_since_visit,
1042: cycles_since_visit,
1043: time_since_mark,
1044: cycles_since_mark
1045: FROM wip_lpn_completions_serials
1046: WHERE header_id = p_ref_id
1047: AND fm_serial_number = p_fm_serial_number);
1048: END Capture_serial_atts;
1049:

Line 1487: FROM wip_lpn_completions_serials

1483: v22,v23,v24,d5,d6,d7,d8,d9,d10,d11,d12,d13,d14,
1484: n7,n8,n9,n10,n11,n12,n13,n14,n15,n16,v25,n17,n18,n19,
1485: n20,n21,n22,n23,n24,n25,n26,n27
1486:
1487: FROM wip_lpn_completions_serials
1488: WHERE fm_serial_number = p_serial_number
1489: AND header_id = p_header_id;
1490:
1491: select gen_object_id