DBA Data[Home] [Help]

APPS.JAI_CMN_RGM_RECORDING_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 1647: FROM JAI_CMN_INVENTORY_ORGS a

1643: jai_constants.register_type_a, modvat_rm_account_id,
1644: jai_constants.register_type_c, modvat_cg_account_id,
1645: jai_constants.register_type_pla, modvat_pla_account_id
1646: )
1647: FROM JAI_CMN_INVENTORY_ORGS a
1648: WHERE organization_id = cp_organization_id
1649: AND ( (cp_location_id IS NOT NULL AND a.location_id = cp_location_id)
1650: OR (cp_location_id IS NULL AND (a.location_id IS NULL OR a.location_id = 0))
1651: );

Line 1663: FROM JAI_CMN_INVENTORY_ORGS a

1659: jai_constants.register_type_a, excise_edu_cess_rm_account ,
1660: jai_constants.register_type_c, excise_edu_cess_cg_account ,
1661: jai_constants.register_type_pla, modvat_pla_account_id
1662: )
1663: FROM JAI_CMN_INVENTORY_ORGS a
1664: WHERE organization_id = cp_organization_id
1665: AND ( (cp_location_id IS NOT NULL AND a.location_id = cp_location_id)
1666: OR (cp_location_id IS NULL AND (a.location_id IS NULL OR a.location_id = 0))
1667: );

Line 1683: FROM JAI_CMN_INVENTORY_ORGS a

1679: jai_constants.register_type_a, SH_CESS_RM_ACCOUNT ,
1680: jai_constants.register_type_c, SH_CESS_CG_ACCOUNT_ID ,
1681: jai_constants.register_type_pla, modvat_pla_account_id
1682: )
1683: FROM JAI_CMN_INVENTORY_ORGS a
1684: WHERE organization_id = cp_organization_id
1685: AND ( (cp_location_id IS NOT NULL AND a.location_id = cp_location_id)
1686: OR (cp_location_id IS NULL AND (a.location_id IS NULL OR a.location_id = 0))
1687: );