DBA Data[Home] [Help]

APPS.PO_TAX_INTERFACE_PVT dependencies on MTL_UNITS_OF_MEASURE

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

3135: WHERE fsp.org_id=pll.org_id)
3136: ,DECODE(p_calling_program, --product_fisc_classification
3137: 'COPY_DOCUMENT', null,
3138: zxldet.product_fisc_classification)
3139: ,(SELECT mum.uom_code FROM mtl_units_of_measure mum
3140: WHERE mum.unit_of_measure=pll.unit_meas_lookup_code) --uom_code
3141: ,DECODE(p_calling_program, --product_type
3142: 'COPY_DOCUMENT', null,
3143: zxldet.product_type)

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

3455: ,(SELECT fsp.inventory_organization_id --product_org_id
3456: FROM financials_system_params_all fsp
3457: WHERE fsp.org_id=pll.org_id)
3458: ,zxldet.product_fisc_classification --product_fisc_classification
3459: ,(SELECT mum.uom_code FROM mtl_units_of_measure mum
3460: WHERE mum.unit_of_measure=pll.unit_meas_lookup_code) --uom_code
3461: ,zxldet.product_type --product_type
3462: ,msib.segment1 --product_code
3463: ,zxldet.product_category --product_category

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

3795: WHERE fsp.org_id=pll.org_id)
3796: ,DECODE(p_calling_program, --product_fisc_classification
3797: 'COPY_DOCUMENT', null,
3798: zxldet.product_fisc_classification)
3799: ,(SELECT mum.uom_code FROM mtl_units_of_measure mum
3800: WHERE mum.unit_of_measure=pll.unit_meas_lookup_code) --uom_code
3801: ,DECODE(p_calling_program, --product_type
3802: 'COPY_DOCUMENT', null,
3803: zxldet.product_type)

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

4111: ,(SELECT fsp.inventory_organization_id --product_org_id
4112: FROM financials_system_params_all fsp
4113: WHERE fsp.org_id=pll.org_id)
4114: ,zxldet.product_fisc_classification --product_fisc_classification
4115: ,(SELECT mum.uom_code FROM mtl_units_of_measure mum
4116: WHERE mum.unit_of_measure=pll.unit_meas_lookup_code) --uom_code
4117: ,zxldet.product_type --product_type
4118: ,msib.segment1 --product_code
4119: ,zxldet.product_category --product_category

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

4446: -- Bug 5335818. Pass in inventory_organization_id
4447: ,(SELECT fsp.inventory_organization_id --product_org_id
4448: FROM financials_system_params_all fsp
4449: WHERE fsp.org_id=prl.org_id)
4450: ,(SELECT mum.uom_code FROM mtl_units_of_measure mum
4451: WHERE mum.unit_of_measure=prl.unit_meas_lookup_code) --uom_code
4452: ,msib.segment1 --product_code
4453: ,prl.destination_organization_id --ship_to_party_id
4454: ,pv.party_id --ship_from_party_id