DBA Data[Home] [Help]

APPS.PO_TAX_INTERFACE_PVT dependencies on MTL_UNITS_OF_MEASURE

Line 2948: ,(SELECT mum.uom_code FROM mtl_units_of_measure mum

2944: WHERE fsp.org_id=pll.org_id)
2945: ,DECODE(p_calling_program, --product_fisc_classification
2946: 'COPY_DOCUMENT', null,
2947: zxldet.product_fisc_classification)
2948: ,(SELECT mum.uom_code FROM mtl_units_of_measure mum
2949: WHERE mum.unit_of_measure=pll.unit_meas_lookup_code) --uom_code
2950: ,DECODE(p_calling_program, --product_type
2951: 'COPY_DOCUMENT', null,
2952: zxldet.product_type)

Line 3255: ,(SELECT mum.uom_code FROM mtl_units_of_measure mum

3251: ,(SELECT fsp.inventory_organization_id --product_org_id
3252: FROM financials_system_params_all fsp
3253: WHERE fsp.org_id=pll.org_id)
3254: ,zxldet.product_fisc_classification --product_fisc_classification
3255: ,(SELECT mum.uom_code FROM mtl_units_of_measure mum
3256: WHERE mum.unit_of_measure=pll.unit_meas_lookup_code) --uom_code
3257: ,zxldet.product_type --product_type
3258: ,msib.segment1 --product_code
3259: ,zxldet.product_category --product_category

Line 3572: ,(SELECT mum.uom_code FROM mtl_units_of_measure mum

3568: -- Bug 5335818. Pass in inventory_organization_id
3569: ,(SELECT fsp.inventory_organization_id --product_org_id
3570: FROM financials_system_params_all fsp
3571: WHERE fsp.org_id=prl.org_id)
3572: ,(SELECT mum.uom_code FROM mtl_units_of_measure mum
3573: WHERE mum.unit_of_measure=prl.unit_meas_lookup_code) --uom_code
3574: ,msib.segment1 --product_code
3575: ,prl.destination_organization_id --ship_to_party_id
3576: ,pv.party_id --ship_from_party_id