eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_WIP_INTEGRATION dependencies on WIP_LPN_COMPLETIONS

Line 67: CURSOR wip_lpn_completions_csr IS

63: l_txn_ret NUMBER;
64: l_fm_serial_number VARCHAR2(30);
65:
66:
67: CURSOR wip_lpn_completions_csr IS
68: SELECT
69: header_id,
70: source_id
71: FROM wip_lpn_completions

Line 71: FROM wip_lpn_completions

67: CURSOR wip_lpn_completions_csr IS
68: SELECT
69: header_id,
70: source_id
71: FROM wip_lpn_completions
72: WHERE source_id = l_source_id
73: AND source_id <> header_id;
74:
75: CURSOR wip_lpn_comp_serials_csr IS

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 91: multiple lots in wip_lpn_completions_lots for the given header_id. */

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
91: multiple lots in wip_lpn_completions_lots for the given header_id. */
92: CURSOR wip_lpn_comp_lots_csr IS
93: SELECT lot_number
94: FROM wip_lpn_completions_lots
95: WHERE header_id = l_temp_header_id;

Line 94: FROM wip_lpn_completions_lots

90: /* Bug: 2976160 : cursor defined to replace 'Select INTO ' to support
91: multiple lots in wip_lpn_completions_lots for the given header_id. */
92: CURSOR wip_lpn_comp_lots_csr IS
93: SELECT lot_number
94: FROM wip_lpn_completions_lots
95: WHERE header_id = l_temp_header_id;
96: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
97: BEGIN
98: l_return_status:= FND_API.G_RET_STS_SUCCESS;

Line 110: FROM wip_lpn_completions

106: source_id
107: INTO
108: l_query_result,
109: l_source_id
110: FROM wip_lpn_completions
111: WHERE header_id = p_header_id;
112:
113: EXCEPTION
114: WHEN NO_DATA_FOUND THEN

Line 130: OPEN wip_lpn_completions_csr;

126: IF (l_debug = 1) THEN
127: mydebug('Backflush: header_id: ' || l_next_transaction_header_id);
128: END IF;
129:
130: OPEN wip_lpn_completions_csr;
131: LOOP
132: FETCH wip_lpn_completions_csr
133: INTO l_temp_header_id,
134: l_temp_source_id;

Line 132: FETCH wip_lpn_completions_csr

128: END IF;
129:
130: OPEN wip_lpn_completions_csr;
131: LOOP
132: FETCH wip_lpn_completions_csr
133: INTO l_temp_header_id,
134: l_temp_source_id;
135: EXIT when wip_lpn_completions_csr%NOTFOUND;
136:

Line 135: EXIT when wip_lpn_completions_csr%NOTFOUND;

131: LOOP
132: FETCH wip_lpn_completions_csr
133: INTO l_temp_header_id,
134: l_temp_source_id;
135: EXIT when wip_lpn_completions_csr%NOTFOUND;
136:
137: -- Insert into mtl_material_transactions_temp
138:
139: --Get value from sequence for next transaction_temp_id

Line 244: FROM wip_lpn_completions

240: NULL,
241: bom_revision,
242: source_project_id,
243: source_task_id
244: FROM wip_lpn_completions
245: WHERE header_id = l_temp_header_id
246: AND source_id = l_temp_source_id);
247:
248: IF (l_debug = 1) THEN

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 603: FROM wip_lpn_completions_lots

599: N_ATTRIBUTE10,
600: vendor_name,
601: supplier_lot_number,
602: territory_code
603: FROM wip_lpn_completions_lots
604: WHERE header_id = l_temp_header_id);
605:
606:
607: IF (l_debug = 1) THEN

Line 612: wms_wip_integration.insert_lot for each lot in wip_lpn_completions_lots table,

608: mydebug('Backflush: Loop thru wip_lpn_comp_lots_rec ');
609: END IF;
610:
611: /* Bug: 2976160 : replaced Select INTO with cursor loop to call
612: wms_wip_integration.insert_lot for each lot in wip_lpn_completions_lots table,
613: for the given header_id. there can be more than one lot . */
614: FOR wip_lpn_comp_lots_rec in wip_lpn_comp_lots_csr
615: LOOP
616: 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 818: CLOSE wip_lpn_completions_csr;

814: CLOSE wip_lpn_comp_serials_csr;
815:
816:
817: END LOOP;
818: CLOSE wip_lpn_completions_csr;
819:
820: IF (l_debug = 1) THEN
821: mydebug('Backflush: Before calling transaction manager');
822: END IF;

Line 853: -- No rows found in wip_lpn_completions

849:
850: END IF;
851:
852: ELSE
853: -- No rows found in wip_lpn_completions
854: l_return_status:=FND_API.G_RET_STS_ERROR;
855: fnd_msg_pub.count_and_get
856: ( p_count => x_msg_count
857: , p_data => x_msg_data

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 1229: FROM wip_lpn_completions_lots

1225: v1,v2,n20,v4,d14,v5,v6,n21,d15,d16,n22,v7,n23,v8,
1226: v9,d18,n24,v10,n25,n26,v11,n27,v12,v13,v14,
1227: v15,v16
1228:
1229: FROM wip_lpn_completions_lots
1230: WHERE header_id = p_ref_id
1231: AND lot_number = p_lot;
1232:
1233:

Line 1410: FROM wip_lpn_completions

1406: l_return_status := FND_API.G_RET_STS_SUCCESS;
1407:
1408: SELECT inventory_item_id
1409: INTO l_item_id
1410: FROM wip_lpn_completions
1411: WHERE header_id = p_header_id;
1412:
1413: SELECT
1414: LAST_UPDATE_DATE,

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

Line 1613: FROM wip_lpn_completions

1609: l_lot_number := p_lot_number;
1610:
1611: SELECT inventory_item_id,organization_id
1612: INTO l_item_id,l_org_id
1613: FROM wip_lpn_completions
1614: WHERE header_id = p_header_id;
1615:
1616: WMS_WIP_Integration.perform_lot_validations
1617: (p_item_id => l_item_id,

Line 1796: FROM wip_lpn_completions_lots

1792: ,N_ATTRIBUTE9
1793: ,territory_code
1794: ,l_object_id
1795: ,status_id
1796: FROM wip_lpn_completions_lots
1797: WHERE header_id = p_header_id
1798: AND lot_number = p_lot_number
1799: );
1800:

Line 1807: FROM wip_lpn_completions_lots

1803: /* bug4073725 changes start */
1804: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1805: SELECT status_id
1806: INTO l_status_id
1807: FROM wip_lpn_completions_lots
1808: WHERE header_id = p_header_id
1809: AND lot_number = p_lot_number;
1810: IF ( l_status_id IS NOT NULL ) THEN
1811: l_status_rec.update_method := inv_material_status_pub.g_update_method_auto;