APPS.WSMPINVL dependencies on WIP_ENTITIES

Line 1906: -- existing in wip_entities, mtl_lot_numbers.

1902: -- end of modification by abedajna on 10/12/00 for performance tuning.
1903:
1904:
1905: -- check if the Resulting Lot will create a duplicate lot already
1906: -- existing in wip_entities, mtl_lot_numbers.
1907:
1908:
1909: /* BEGIN
1910: ** SELECT 1

Line 1916: ** FROM wip_entities

1912: ** FROM dual
1913: ** WHERE not exists
1914: ** (
1915: ** SELECT 1
1916: ** FROM wip_entities
1917: ** WHERE wip_entity_name = crec.lot_number
1918: ** AND organization_id = crec.organization_id
1919: ** UNION
1920: ** SELECT 1

Line 1940: FROM wip_entities

1936: x_dummy := 0;
1937:
1938: SELECT 1
1939: into x_dummy
1940: FROM wip_entities
1941: WHERE wip_entity_name = crec.lot_number
1942: AND organization_id = crec.organization_id
1943: UNION ALL
1944: SELECT 1

Line 2424: ** exist in wip_entities or mtl_lot_numbers tables

2420:
2421: /*
2422: ** For a MERGE txn, ensure that the Resulting Lot
2423: ** is SAME as the STARTING LOT OR it does NOT exist already
2424: ** exist in wip_entities or mtl_lot_numbers tables
2425: */
2426:
2427: SELECT transaction_type_id
2428: INTO x_transaction_type_id

Line 2439: FROM wip_entities

2435: WHERE header_id = p_header_id
2436: and (not exists
2437: (
2438: SELECT 1
2439: FROM wip_entities
2440: WHERE wip_entity_name = crec.lot_number
2441: AND organization_id = crec.organization_id
2442: UNION ALL
2443: SELECT 1