APPS.INV_MOVE_ORDER_PUB dependencies on DUAL

Line 499: FROM DUAL

495: x_trolin_tbl(l_index).to_locator_id IS NOT NULL THEN
496: BEGIN
497: SELECT 'Y'
498: INTO l_result
499: FROM DUAL
500: WHERE exists (
501: SELECT secondary_locator
502: FROM mtl_secondary_locators
503: WHERE organization_id = x_trolin_tbl(l_index).organization_id

Line 515: FROM DUAL

511: ELSIF l_restrict_subinventories_code = 1 and x_trolin_tbl(l_index).to_subinventory_code is NOT NULL Then
512: BEGIN
513: SELECT 'Y'
514: INTO l_result
515: FROM DUAL
516: WHERE exists (
517: SELECT secondary_inventory
518: FROM mtl_item_sub_inventories
519: WHERE organization_id = x_trolin_tbl(l_index).organization_id

Line 559: FROM DUAL

555: IF l_restrict_subinventories_code = 1 and x_trolin_tbl(l_index).from_subinventory_code is NOT NULL Then
556: BEGIN
557: SELECT 'Y'
558: INTO l_result
559: FROM DUAL
560: WHERE exists (
561: SELECT secondary_inventory
562: FROM mtl_item_sub_inventories
563: WHERE organization_id = x_trolin_tbl(l_index).organization_id

Line 781: FROM DUAL;

777: /* ELSE --} {
778: --print_debug('in insert',l_api_name);
779: SELECT MTL_TXN_REQUEST_LINES_S.NEXTVAL
780: INTO x_trolin_tbl(l_index).line_id
781: FROM DUAL;
782: x_trolin_tbl(l_index).status_date := SYSDATE;
783: x_trolin_tbl(l_index).creation_date := SYSDATE;
784: x_trolin_tbl(l_index).created_by := fnd_global.user_id;
785: x_trolin_tbl(l_index).last_update_date := SYSDATE;

Line 972: FROM DUAL;

968: print_debug('Creating MO Line for WDD = '||x_trolin_tbl(l_index).txn_source_line_detail_id,l_api_name);
969: End If;
970: SELECT MTL_TXN_REQUEST_LINES_S.NEXTVAL
971: INTO x_trolin_tbl(l_index).line_id
972: FROM DUAL;
973:
974: x_trolin_tbl(l_index).status_date := SYSDATE;
975: x_trolin_tbl(l_index).creation_date := SYSDATE;
976: x_trolin_tbl(l_index).created_by := fnd_global.user_id;