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.WSMPINVL dependencies on WSM_STARTING_LOTS_INTERFACE

Line 419: select count(1) into rep_flag_count from wsm_starting_lots_interface wsli

415: lProcLocation := 100;
416:
417: -- added by sisankar for bug 4920235
418:
419: select count(1) into rep_flag_count from wsm_starting_lots_interface wsli
420: where wsli.representative_flag='Y' and wsli.header_id=txn.header_id;
421:
422: IF rep_flag_count <> 1 THEN
423:

Line 1033: FROM wsm_starting_lots_interface

1029:
1030: cursor c is
1031: SELECT
1032: organization_id
1033: FROM wsm_starting_lots_interface
1034: WHERE header_id = p_header_id;
1035:
1036: x_dummy NUMBER;
1037:

Line 1089: FROM wsm_starting_lots_interface

1085: locator_id,
1086: revision,
1087: last_updated_by,
1088: created_by
1089: FROM wsm_starting_lots_interface
1090: WHERE header_id = p_header_id;
1091: --bugfix 1823316
1092:
1093: cursor lot (org_id NUMBER, lot_n VARCHAR2) is

Line 1838: ** FROM wsm_starting_lots_interface s

1834: ** into x_dummy
1835: ** FROM dual
1836: ** WHERE not exists
1837: ** (SELECT 1
1838: ** FROM wsm_starting_lots_interface s
1839: ** WHERE s.header_id = p_header_id
1840: ** and s.lot_number = crec.lot_number);
1841: ** EXCEPTION
1842: **

Line 1863: FROM wsm_starting_lots_interface s

1859: x_dummy := 0;
1860:
1861: SELECT 1
1862: into x_dummy
1863: FROM wsm_starting_lots_interface s
1864: WHERE s.header_id = p_header_id
1865: and s.lot_number = crec.lot_number;
1866:
1867:

Line 2004: FROM wsm_starting_lots_interface

2000: BEGIN
2001: lprocLocation := 80;
2002: SELECT 1
2003: into x_dummy
2004: FROM wsm_starting_lots_interface
2005: WHERE header_id = p_header_id
2006: and lot_number = crec.lot_number;
2007:
2008:

Line 2032: FROM wsm_starting_lots_interface

2028: lprocLocation := 90;
2029: BEGIN
2030: SELECT inventory_item_id
2031: into x_dummy
2032: FROM wsm_starting_lots_interface
2033: WHERE header_id = p_header_id
2034: and lot_number = crec.lot_number
2035: and inventory_item_id = crec.inventory_item_id; --Bug#1844972
2036:

Line 2117: ** FROM wsm_starting_lots_interface

2113: ** into x_dummy
2114: ** FROM dual
2115: ** WHERE exists
2116: ** (SELECT 1
2117: ** FROM wsm_starting_lots_interface
2118: ** WHERE header_id = p_header_id
2119: ** and inventory_item_id = crec.inventory_item_id
2120: ** and organization_id = crec.organization_id
2121: ** and nvl(revision,'@@@') = nvl(crec.revision,'@@@'));

Line 2137: FROM wsm_starting_lots_interface

2133: BEGIN
2134:
2135: SELECT 1
2136: into x_dummy
2137: FROM wsm_starting_lots_interface
2138: WHERE header_id = p_header_id
2139: and inventory_item_id = crec.inventory_item_id
2140: and organization_id = crec.organization_id
2141: and nvl(revision,'@@@') = nvl(crec.revision,'@@@');

Line 2452: FROM wsm_starting_lots_interface

2448: ) -- Should not be able to create a new lot for the SAME item.
2449: or exists -- But, should be able to create lot if it exists with a
2450: ( -- DIFFERENT item.
2451: SELECT 1
2452: FROM wsm_starting_lots_interface
2453: WHERE header_id = p_header_id
2454: and lot_number = crec.lot_number
2455: )
2456: );

Line 2473: ** FROM wsm_starting_lots_interface

2469: ** into x_dummy
2470: ** FROM dual
2471: ** WHERE not exists
2472: ** (SELECT count(*)
2473: ** FROM wsm_starting_lots_interface
2474: ** WHERE header_id = p_header_id
2475: ** group by lot_number
2476: ** having count(*) > 1);
2477: ** EXCEPTION when others THEN

Line 2493: FROM wsm_starting_lots_interface

2489: x_dummy := 0;
2490:
2491: SELECT 1
2492: into x_dummy
2493: FROM wsm_starting_lots_interface
2494: WHERE header_id = p_header_id
2495: group by lot_number
2496: having count(*) > 1;
2497:

Line 2541: FROM wsm_starting_lots_interface

2537: BEGIN
2538:
2539: SELECT count(*)
2540: INTO x_start_ct
2541: FROM wsm_starting_lots_interface
2542: WHERE header_id = p_header_id;
2543:
2544: SELECT count(*)
2545: INTO x_result_ct

Line 2590: ** FROM wsm_starting_lots_interface s1,

2586: ** into x_dummy
2587: ** FROM dual
2588: ** WHERE not exists
2589: ** ( SELECT 1
2590: ** FROM wsm_starting_lots_interface s1,
2591: ** wsm_starting_lots_interface s2
2592: ** WHERE s1.header_id = p_header_id
2593: ** and s2.header_id = p_header_id
2594: ** and (s1.inventory_item_id <> s2.inventory_item_id

Line 2591: ** wsm_starting_lots_interface s2

2587: ** FROM dual
2588: ** WHERE not exists
2589: ** ( SELECT 1
2590: ** FROM wsm_starting_lots_interface s1,
2591: ** wsm_starting_lots_interface s2
2592: ** WHERE s1.header_id = p_header_id
2593: ** and s2.header_id = p_header_id
2594: ** and (s1.inventory_item_id <> s2.inventory_item_id
2595: ** or nvl(s1.revision, '!@#') <> nvl(s1.revision, '!@#')

Line 2614: FROM wsm_starting_lots_interface s1,

2610: BEGIN
2611: x_dummy := 0;
2612: SELECT 1
2613: into x_dummy
2614: FROM wsm_starting_lots_interface s1,
2615: wsm_starting_lots_interface s2
2616: WHERE s1.header_id = p_header_id
2617: and s2.header_id = p_header_id
2618: and (s1.inventory_item_id <> s2.inventory_item_id

Line 2615: wsm_starting_lots_interface s2

2611: x_dummy := 0;
2612: SELECT 1
2613: into x_dummy
2614: FROM wsm_starting_lots_interface s1,
2615: wsm_starting_lots_interface s2
2616: WHERE s1.header_id = p_header_id
2617: and s2.header_id = p_header_id
2618: and (s1.inventory_item_id <> s2.inventory_item_id
2619: or nvl(s1.revision, '!@#') <> nvl(s1.revision, '!@#'));

Line 2969: FROM wsm_starting_lots_interface

2965: lProcLocation := 100;
2966:
2967: SELECT count(*)
2968: INTO x_start_ct
2969: FROM wsm_starting_lots_interface
2970: WHERE header_id = p_header_id;
2971:
2972: lProcLocation := 110;
2973:

Line 3056: FROM wsm_starting_lots_interface

3052: lProcLocation := 120;
3053:
3054: SELECT sum(quantity)
3055: into x_start_ct1
3056: FROM wsm_starting_lots_interface
3057: WHERE header_id = p_header_id;
3058:
3059: lProcLocation := 130;
3060:

Line 3164: FROM wsm_starting_lots_interface

3160:
3161: l_stmt_num :=10;
3162: SELECT sum(quantity)
3163: INTO x_start
3164: FROM wsm_starting_lots_interface
3165: WHERE header_id = p_header_id;
3166:
3167: l_stmt_num :=20;
3168: SELECT sum(quantity)

Line 3266: FROM wsm_starting_lots_interface

3262: attribute12,
3263: attribute13,
3264: attribute14,
3265: attribute15
3266: FROM wsm_starting_lots_interface
3267: WHERE header_id = p_header_id;
3268:
3269: If SQL%ROWCOUNT = 0 Then
3270:

Line 3375: wsm_starting_lots_interface a

3371: a.quantity,
3372: a.representative_flag -- added by sisankar for bug 4920235
3373: FROM
3374: mtl_lot_numbers x,
3375: wsm_starting_lots_interface a
3376: WHERE header_id = p_header_id
3377: AND X.lot_number = a.lot_number
3378: -- bugfix 1995378: added the orgn id and inventory item id condition
3379: AND x.organization_id = a.organization_id

Line 5145: FROM wsm_starting_lots_interface s,

5141: s.attribute12,
5142: s.attribute13,
5143: s.attribute14,
5144: s.attribute15
5145: FROM wsm_starting_lots_interface s,
5146: wsm_lot_split_merges_interface h
5147: WHERE h.header_id = p_header_id
5148: and s.header_id = h.header_id;
5149: