APPS.PON_VALIDATE_ITEM_PRICES_INT dependencies on FND_LOOKUP_VALUES

Line 2889: fnd_lookup_values lookups

2885: AND batch_id = p_batch_id
2886: AND EXISTS (SELECT 1
2887: FROM
2888: pon_auc_price_elements_int pfs,
2889: fnd_lookup_values lookups
2890: WHERE
2891: pfs.batch_id = pon_item_prices_interface.batch_id
2892: AND pfs.auction_header_id = pon_item_prices_interface.auction_header_id
2893: AND pfs.interface_line_id = pon_item_prices_interface.interface_line_id

Line 3145: FROM fnd_lookup_values_vl

3141: -- CLM: Event Based Delivery Management
3142:
3143: update pon_item_prices_interface p
3144: set p.CLM_DELIVERY_EVENT_CODE = (SELECT lookup_code
3145: FROM fnd_lookup_values_vl
3146: WHERE lookup_type = 'CLM_DELIVERY_EVENT'
3147: AND meaning = p.CLM_DELIVERY_EVENT);
3148:
3149: insert into PON_INTERFACE_ERRORS

Line 3170: FROM fnd_lookup_values_vl

3166: and CLM_DELIVERY_EVENT IS NOT NULL;
3167:
3168: update pon_item_prices_interface p
3169: set p.CLM_DELIVERY_PERIOD_UOM_CODE = (SELECT lookup_code
3170: FROM fnd_lookup_values_vl
3171: WHERE lookup_type = 'CLM_PERIOD'
3172: AND meaning = p.CLM_DELIVERY_PERIOD_UOM);
3173:
3174: insert into PON_INTERFACE_ERRORS

Line 3195: FROM fnd_lookup_values_vl

3191: and CLM_DELIVERY_PERIOD_UOM IS NOT NULL;
3192:
3193: update pon_item_prices_interface p
3194: set p.CLM_POP_DURATION_UOM_CODE = (SELECT lookup_code
3195: FROM fnd_lookup_values_vl
3196: WHERE lookup_type = 'CLM_PERIOD'
3197: AND meaning = p.CLM_POP_DURATION_UOM);
3198:
3199: insert into PON_INTERFACE_ERRORS

Line 3680: FROM FND_LOOKUP_VALUES

3676: where batch_id = p_batch_id
3677: AND CLM_CONTRACT_TYPE IS NOT NULL
3678: AND CLM_CONTRACT_TYPE NOT IN
3679: (SELECT LOOKUP_CODE
3680: FROM FND_LOOKUP_VALUES
3681: WHERE LOOKUP_TYPE = 'PO_FEDERAL_CONTRACT_TYPES_QTY'
3682: AND LANGUAGE = USERENV('LANG')
3683: AND ENABLED_FLAG = 'Y'
3684: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE - 1) AND NVL(END_DATE_ACTIVE, SYSDATE + 1)

Line 3711: FROM FND_LOOKUP_VALUES

3707: where batch_id = p_batch_id
3708: AND CLM_COST_CONSTRAINT IS NOT NULL
3709: AND CLM_COST_CONSTRAINT NOT IN
3710: (SELECT LOOKUP_CODE
3711: FROM FND_LOOKUP_VALUES
3712: WHERE LOOKUP_TYPE = 'PO_FEDERAL_COST_CONSTRAINTS'
3713: AND LANGUAGE = USERENV('LANG')
3714: AND ENABLED_FLAG = 'Y'
3715: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE - 1) AND NVL(END_DATE_ACTIVE, SYSDATE + 1)