DBA Data[Home] [Help]

APPS.PO_TAX_INTERFACE_PVT dependencies on PO_LOCATIONS_S

Line 3174: ,PO_LOCATIONS_S.get_location_code(pll.ship_to_location_id) --line_trx_user_key2

3170: ,null --ref_doc_event_class_code
3171: ,null --ref_doc_trx_id
3172: ,null --ref_doc_line_id
3173: ,pl.line_num --line_trx_user_key1
3174: ,PO_LOCATIONS_S.get_location_code(pll.ship_to_location_id) --line_trx_user_key2
3175: -- Bug 5079867. Ordering of complex work payment lines in ATI page
3176: ,DECODE(pll.payment_type, null, 0, --line_trx_user_key3
3177: 'DELIVERY', 1,
3178: 'ADVANCE', 2, 3)

Line 3501: ,PO_LOCATIONS_S.get_location_code(pll.ship_to_location_id) --line_trx_user_key2

3497: ,DECODE(pr.release_type, --ref_doc_line_id
3498: PO_CONSTANTS_SV.SCHEDULED, pll.po_line_id,
3499: null)
3500: ,pl.line_num --line_trx_user_key1
3501: ,PO_LOCATIONS_S.get_location_code(pll.ship_to_location_id) --line_trx_user_key2
3502: ,DECODE(pll.payment_type, --trx_line_number
3503: 'ADVANCE', null,
3504: 'DELIVERY', null,
3505: pll.shipment_num)

Line 3834: ,PO_LOCATIONS_S.get_location_code(pll.ship_to_location_id) --line_trx_user_key2

3830: ,null --ref_doc_event_class_code
3831: ,null --ref_doc_trx_id
3832: ,null --ref_doc_line_id
3833: ,pl.line_num --line_trx_user_key1
3834: ,PO_LOCATIONS_S.get_location_code(pll.ship_to_location_id) --line_trx_user_key2
3835: -- Bug 5079867. Ordering of complex work payment lines in ATI page
3836: ,DECODE(pll.payment_type, null, 0, --line_trx_user_key3
3837: 'DELIVERY', 1,
3838: 'ADVANCE', 2, 3)

Line 4157: ,PO_LOCATIONS_S.get_location_code(pll.ship_to_location_id) --line_trx_user_key2

4153: ,DECODE(pr.release_type, --ref_doc_line_id
4154: PO_CONSTANTS_SV.SCHEDULED, pll.po_line_id,
4155: null)
4156: ,pl.line_num --line_trx_user_key1
4157: ,PO_LOCATIONS_S.get_location_code(pll.ship_to_location_id) --line_trx_user_key2
4158: ,DECODE(pll.payment_type, --trx_line_number
4159: 'ADVANCE', null,
4160: 'DELIVERY', null,
4161: pll.shipment_num)