APPS.PO_VAL_DISTRIBUTIONS2 dependencies on DUAL

Line 255: FROM DUAL

251: 'DELIVER_TO_LOCATION_ID',
252: p_deliver_to_location_id_tbl(i),
253: 'DELIVER_TO_LOCATION_ID',
254: p_deliver_to_location_id_tbl(i)
255: FROM DUAL
256: WHERE p_deliver_to_location_id_tbl(i) IS NOT NULL
257: AND NOT EXISTS(
258: SELECT 1
259: FROM hr_locations

Line 370: FROM DUAL

366: 'DELIVER_TO_PERSON_ID',
367: p_deliver_to_person_id_tbl(i),
368: 'DELIVER_TO_PERSON',
369: p_deliver_to_person_id_tbl(i)
370: FROM DUAL
371: WHERE NOT EXISTS(
372: SELECT
373: /*+ INDEX(P PER_PEOPLE_F_PK) */
374: 1

Line 588: FROM DUAL

584: 'DESTINATION_TYPE_CODE',
585: p_dest_type_code_tbl(i),
586: 'DESTINATION_TYPE',
587: p_dest_type_code_tbl(i)
588: FROM DUAL
589: WHERE p_dest_type_code_tbl(i) IS NOT NULL
590: AND NOT EXISTS(SELECT 1
591: FROM po_lookup_codes
592: WHERE lookup_type = 'DESTINATION TYPE'

Line 710: FROM DUAL

706: 'DESTINATION_SUBINVENTORY',
707: p_destination_subinv_tbl(i),
708: 'DESTINATION_SUBINVENTORY',
709: p_destination_subinv_tbl(i)
710: FROM DUAL
711: WHERE p_dest_type_code_tbl(i) = 'INVENTORY'
712: AND p_destination_subinv_tbl(i) IS NOT NULL
713: AND NOT EXISTS(
714: SELECT 1

Line 761: FROM DUAL

757: 'DESTINATION_SUBINVENTORY',
758: p_destination_subinv_tbl(i),
759: 'DESTINATION_SUBINVENTORY',
760: p_destination_subinv_tbl(i)
761: FROM DUAL
762: WHERE p_destination_subinv_tbl(i) IS NOT NULL
763: AND p_dest_type_code_tbl(i) = 'INVENTORY'
764: AND p_loc_outsourced_assembly_tbl(i) = 1 /* SHIKYU item */
765: AND EXISTS(

Line 872: FROM DUAL

868: 'WIP_REPETITIVE_SCHEDULE_ID',
869: p_wip_rep_schedule_id_tbl(i),
870: 'WIP_REPETITIVE_SCHEDULE_ID',
871: p_wip_rep_schedule_id_tbl(i)
872: FROM DUAL
873: WHERE p_dest_type_code_tbl(i) = 'SHOP FLOOR'
874: AND p_wip_entity_id_tbl(i) IS NOT NULL
875: AND p_wip_rep_schedule_id_tbl(i) IS NOT NULL
876: AND NOT EXISTS(

Line 908: FROM DUAL

904: 'WIP_ENTITY_ID',
905: p_wip_entity_id_tbl(i),
906: 'WIP_ENTITY_ID',
907: p_wip_entity_id_tbl(i)
908: FROM DUAL
909: WHERE p_dest_type_code_tbl(i) = 'SHOP FLOOR'
910: AND p_wip_entity_id_tbl(i) IS NOT NULL
911: AND p_wip_rep_schedule_id_tbl(i) IS NULL
912: AND NOT EXISTS(

Line 1039: FROM DUAL

1035: 'CHARGE_ACCOUNT_ID',
1036: p_charge_account_id_tbl(i),
1037: decode(p_charge_account_id_tbl(i), NULL, NULL, 'CHARGE_ACCOUNT'),
1038: decode(p_charge_account_id_tbl(i), NULL, NULL, p_charge_account_id_tbl(i))
1039: FROM DUAL
1040: WHERE (p_charge_account_id_tbl(i) IS NULL OR
1041: (p_charge_account_id_tbl(i) IS NOT NULL AND
1042: NOT EXISTS(
1043: SELECT NULL

Line 1131: FROM DUAL

1127: 'BUDGET_ACCOUNT_ID',
1128: p_budget_account_id_tbl(i),
1129: 'BUDGET_ACCOUNT',
1130: p_budget_account_id_tbl(i)
1131: FROM DUAL
1132: WHERE (p_po_encumberance_flag = 'Y' AND
1133: p_dest_type_code_tbl(i) <> 'SHOP FLOOR' AND
1134: p_budget_account_id_tbl(i) IS NULL)
1135: OR ( p_budget_account_id_tbl(i) IS NOT NULL

Line 1222: FROM DUAL

1218: p_column_name,
1219: p_account_id_tbl(i),
1220: p_token_name,
1221: p_account_id_tbl(i)
1222: FROM DUAL
1223: WHERE p_account_id_tbl(i) IS NOT NULL
1224: AND NOT EXISTS(
1225: SELECT NULL
1226: FROM gl_code_combinations gcc