DBA Data[Home] [Help]

APPS.PON_VALIDATE_ITEM_PRICES_INT dependencies on PO_LINE_TYPES_B

Line 3631: AND P1.LINE_TYPE_ID NOT IN (SELECT LINE_TYPE_ID FROM po_line_types_b WHERE ORDER_TYPE_LOOKUP_CODE = 'AMOUNT')

3627: interface_line_id
3628: from pon_item_prices_interface P1
3629: where batch_id = p_batch_id
3630: AND P1.CLM_AMOUNT IS NOT NULL
3631: AND P1.LINE_TYPE_ID NOT IN (SELECT LINE_TYPE_ID FROM po_line_types_b WHERE ORDER_TYPE_LOOKUP_CODE = 'AMOUNT')
3632: );
3633:
3634: /* CLM_UNIT_PRICE */
3635: insert into PON_INTERFACE_ERRORS

Line 3653: AND P1.LINE_TYPE_ID NOT IN (SELECT LINE_TYPE_ID FROM po_line_types_b WHERE ORDER_TYPE_LOOKUP_CODE = 'QUANTITY')

3649: interface_line_id
3650: from pon_item_prices_interface P1
3651: where batch_id = p_batch_id
3652: AND P1.CLM_UNIT_PRICE IS NOT NULL
3653: AND P1.LINE_TYPE_ID NOT IN (SELECT LINE_TYPE_ID FROM po_line_types_b WHERE ORDER_TYPE_LOOKUP_CODE = 'QUANTITY')
3654: );
3655:
3656:
3657: /* CLM_CONTRACT_TYPE*/