DBA Data[Home] [Help]

APPS.PO_AP_PURGE_PVT dependencies on PO_PRICE_DIFFERENTIALS

Line 1653: FROM po_price_differentials PPD

1649: PRL.source_type_code = 'INVENTORY'
1650: OR
1651: EXISTS (
1652: SELECT NULL
1653: FROM po_price_differentials PPD
1654: WHERE PPD.entity_type = 'REQ LINE'
1655: AND PPD.entity_id = PRL.requisition_line_id
1656: AND PPD.last_update_date >
1657: p_last_activity_date)

Line 3245: FROM po_price_differentials PPD

3241: RL.source_type_code = 'INVENTORY'
3242: OR
3243: EXISTS (
3244: SELECT NULL
3245: FROM po_price_differentials PPD
3246: WHERE PPD.entity_type = 'REQ LINE'
3247: AND PPD.entity_id =
3248: RL.requisition_line_id
3249: AND PPD.last_update_date >

Line 3388: FROM po_price_differentials PPD

3384: AND (PL.last_update_date > p_last_activity_date
3385: OR
3386: EXISTS
3387: (SELECT NULL
3388: FROM po_price_differentials PPD
3389: WHERE PPD.entity_type IN ('PO LINE',
3390: 'BLANKET LINE')
3391: AND PPD.entity_id = PL.po_line_id
3392: AND PPD.last_update_date >

Line 3402: FROM po_price_differentials PPD

3398: AND (PLL.last_update_date >p_last_activity_date
3399: OR
3400: EXISTS
3401: (SELECT NULL
3402: FROM po_price_differentials PPD
3403: WHERE PPD.entity_type = 'PRICE BREAK'
3404: AND PPD.entity_id =
3405: PLL.line_location_id
3406: AND PPD.last_update_date >

Line 3457: FROM po_price_differentials PPD

3453: AND (PL.last_update_date > p_last_activity_date
3454: OR
3455: EXISTS
3456: (SELECT NULL
3457: FROM po_price_differentials PPD
3458: WHERE PPD.entity_type IN ('PO LINE',
3459: 'BLANKET LINE')
3460: AND PPD.entity_id = PL.po_line_id
3461: AND PPD.last_update_date >

Line 3471: FROM po_price_differentials PPD

3467: AND (PLL.last_update_date > p_last_activity_date
3468: OR
3469: EXISTS
3470: (SELECT NULL
3471: FROM po_price_differentials PPD
3472: WHERE PPD.entity_type = 'PRICE BREAK'
3473: AND PPD.entity_id =
3474: PLL.line_location_id
3475: AND PPD.last_update_date >

Line 3530: FROM po_price_differentials PPD

3526: RL.source_type_code = 'INVENTORY'
3527: OR
3528: EXISTS (
3529: SELECT NULL
3530: FROM po_price_differentials PPD
3531: WHERE PPD.entity_type = 'REQ LINE'
3532: AND PPD.entity_id =
3533: RL.requisition_line_id
3534: AND PPD.last_update_date >