APPS.WSMPINVL dependencies on DUAL

Line 514: ** from dual;

510:
511: -- commented out by abedajna for perf. tuning
512: /* select wsm_split_merge_transactions_s.nextval
513: ** into txn.transaction_id
514: ** from dual;
515: **
516: **
517: ** update wsm_lot_split_merges_interface
518: ** set transaction_id = txn.transaction_id

Line 975: FROM DUAL;

971: BEGIN
972:
973: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
974: INTO X_Header_Id
975: FROM DUAL;
976:
977: return(X_Header_Id);
978:
979: END Get_Header_Id;

Line 1224: FROM DUAL

1220:
1221: /* ST 3303884 : code to check if serial-controlled */
1222:
1223: SELECT 1 into x_dummy
1224: FROM DUAL
1225: Where exists (select 1
1226: From mtl_transaction_lots_temp
1227: WHERE lot_number=crec.lot_number);
1228:

Line 1687: FROM DUAL

1683:
1684:
1685:
1686: SELECT 1 into x_dummy
1687: FROM DUAL
1688: Where exists (select 1
1689: From mtl_transaction_lots_temp
1690: WHERE lot_number=crec.lot_number);
1691:

Line 1835: ** FROM dual

1831: -- commented out by abedajna on 10/12/00 for performance tuning.
1832: /* BEGIN
1833: ** SELECT 1
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

Line 1912: ** FROM dual

1908:
1909: /* BEGIN
1910: ** SELECT 1
1911: ** into x_dummy
1912: ** FROM dual
1913: ** WHERE not exists
1914: ** (
1915: ** SELECT 1
1916: ** FROM wip_entities

Line 2114: ** FROM dual

2110: -- commented out by abedajna on 10/13/00 for performance tuning.
2111: /* BEGIN
2112: ** SELECT 1
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

Line 2191: ** SELECT 1 into x_dummy FROM dual WHERE exists(

2187: -- Check for the valid subinventory code.
2188:
2189: -- commented out by abedajna on 10/12/00 for perf. tuning
2190: /*
2191: ** SELECT 1 into x_dummy FROM dual WHERE exists(
2192: ** SELECT 1
2193: ** FROM MTL_SUBINVENTORIES_VAL_V MSVV,
2194: ** MTL_SYSTEM_ITEMS MSI
2195: ** WHERE MSVV.ORGANIZATION_ID = crec.ORGANIZATION_ID

Line 2470: ** FROM dual

2466: --commented out by abedajna on 10/12/00 for perf. tuning
2467: /* BEGIN
2468: ** SELECT 1
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

Line 2587: ** FROM dual

2583: -- commented out by abedajna on 10/13/00 for performance tuning.
2584: /* BEGIN
2585: ** SELECT 1
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

Line 2837: FROM dual

2833: /*
2834: BEGIN
2835: SELECT 1
2836: into x_dummy
2837: FROM dual
2838: WHERE exists (
2839: SELECT 1
2840: FROM fnd_user_responsibility f,
2841: fnd_responsibility_tl r

Line 3607: -- select decode(count(1),0,'N','Y') into x_lot_exists from dual where exists

3603: x_lot_attr_entered:=0;
3604: x_rlot_context_entered:=null;
3605: end;
3606:
3607: -- select decode(count(1),0,'N','Y') into x_lot_exists from dual where exists
3608: -- (select 1 from mtl_lot_numbers mln where mln.lot_number=rlot.lot_number and
3609: -- mln.inventory_item_id=rlot.inventory_item_id and
3610: -- mln.organization_id=x_org_id);
3611:

Line 4325: **FROM DUAL;

4321:
4322: --commented out by abedajna for perf. tuning
4323: /*SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
4324: **INTO X_Temp_Id
4325: **FROM DUAL;
4326: */
4327:
4328: l_stmt_num :=20;
4329:

Line 4721: **FROM DUAL;

4717:
4718: --commented out by abedajna for perf. tuning
4719: /*SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
4720: **INTO X_Temp_Id
4721: **FROM DUAL;
4722: */
4723:
4724: l_stmt_num :=20;
4725: SELECT msi.primary_uom_code