APPS.PO_VAL_DISTRIBUTIONS2 dependencies on DUAL

Line 267: FROM DUAL

263: 'DELIVER_TO_LOCATION_ID',
264: p_deliver_to_location_id_tbl(i),
265: 'DELIVER_TO_LOCATION_ID',
266: p_deliver_to_location_id_tbl(i)
267: FROM DUAL
268: WHERE p_deliver_to_location_id_tbl(i) IS NOT NULL
269: AND NOT EXISTS(
270: SELECT 1
271: FROM hr_locations

Line 382: FROM DUAL

378: 'DELIVER_TO_PERSON_ID',
379: p_deliver_to_person_id_tbl(i),
380: 'DELIVER_TO_PERSON',
381: p_deliver_to_person_id_tbl(i)
382: FROM DUAL
383: WHERE NOT EXISTS(
384: SELECT
385: /*+ INDEX(P PER_PEOPLE_F_PK) */
386: 1

Line 600: FROM DUAL

596: 'DESTINATION_TYPE_CODE',
597: p_dest_type_code_tbl(i),
598: 'DESTINATION_TYPE',
599: p_dest_type_code_tbl(i)
600: FROM DUAL
601: WHERE p_dest_type_code_tbl(i) IS NOT NULL
602: AND NOT EXISTS(SELECT 1
603: FROM po_lookup_codes
604: WHERE lookup_type = 'DESTINATION TYPE'

Line 722: FROM DUAL

718: 'DESTINATION_SUBINVENTORY',
719: p_destination_subinv_tbl(i),
720: 'DESTINATION_SUBINVENTORY',
721: p_destination_subinv_tbl(i)
722: FROM DUAL
723: WHERE p_dest_type_code_tbl(i) = 'INVENTORY'
724: AND p_destination_subinv_tbl(i) IS NOT NULL
725: AND NOT EXISTS(
726: SELECT 1

Line 773: FROM DUAL

769: 'DESTINATION_SUBINVENTORY',
770: p_destination_subinv_tbl(i),
771: 'DESTINATION_SUBINVENTORY',
772: p_destination_subinv_tbl(i)
773: FROM DUAL
774: WHERE p_destination_subinv_tbl(i) IS NOT NULL
775: AND p_dest_type_code_tbl(i) = 'INVENTORY'
776: AND p_loc_outsourced_assembly_tbl(i) = 1 /* SHIKYU item */
777: AND EXISTS(

Line 884: FROM DUAL

880: 'WIP_REPETITIVE_SCHEDULE_ID',
881: p_wip_rep_schedule_id_tbl(i),
882: 'WIP_REPETITIVE_SCHEDULE_ID',
883: p_wip_rep_schedule_id_tbl(i)
884: FROM DUAL
885: WHERE p_dest_type_code_tbl(i) = 'SHOP FLOOR'
886: AND p_wip_entity_id_tbl(i) IS NOT NULL
887: AND p_wip_rep_schedule_id_tbl(i) IS NOT NULL
888: AND NOT EXISTS(

Line 920: FROM DUAL

916: 'WIP_ENTITY_ID',
917: p_wip_entity_id_tbl(i),
918: 'WIP_ENTITY_ID',
919: p_wip_entity_id_tbl(i)
920: FROM DUAL
921: WHERE p_dest_type_code_tbl(i) = 'SHOP FLOOR'
922: AND p_wip_entity_id_tbl(i) IS NOT NULL
923: AND p_wip_rep_schedule_id_tbl(i) IS NULL
924: AND NOT EXISTS(

Line 1073: FROM DUAL

1069: 'CHARGE_ACCOUNT_ID',
1070: p_charge_account_id_tbl(i),
1071: decode(p_charge_account_id_tbl(i), NULL, NULL, 'CHARGE_ACCOUNT'),
1072: decode(p_charge_account_id_tbl(i), NULL, NULL, p_charge_account_id_tbl(i))
1073: FROM DUAL
1074: WHERE (p_charge_account_id_tbl(i) IS NULL OR
1075: (p_charge_account_id_tbl(i) IS NOT NULL AND
1076: NOT EXISTS(
1077: SELECT NULL

Line 1169: FROM DUAL

1165: 'BUDGET_ACCOUNT_ID',
1166: p_budget_account_id_tbl(i),
1167: 'BUDGET_ACCOUNT',
1168: p_budget_account_id_tbl(i)
1169: FROM DUAL
1170: WHERE (p_po_encumberance_flag = 'Y' AND
1171: (p_dest_type_code_tbl(i) <> 'SHOP FLOOR' AND p_distribution_type_tbl(i) <> 'PREPAYMENT') AND
1172: -- PDOI for Complex PO Project
1173: (p_dest_type_code_tbl(i) <> 'SHOP FLOOR' OR (p_dest_type_code_tbl(i) = 'SHOP FLOOR'

Line 1263: FROM DUAL

1259: p_column_name,
1260: p_account_id_tbl(i),
1261: p_token_name,
1262: p_account_id_tbl(i)
1263: FROM DUAL
1264: WHERE p_account_id_tbl(i) IS NOT NULL
1265: AND NOT EXISTS(
1266: SELECT NULL
1267: FROM gl_code_combinations gcc