DBA Data[Home] [Help]

APPS.GMF_MIGRATION dependencies on MTL_PARAMETERS

Line 3988: mtl_parameters z,

3984: = (
3985: SELECT z.master_organization_id,
3986: y.inventory_item_id
3987: FROM ic_item_mst_b_mig y,
3988: mtl_parameters z,
3989: hr_organization_information hoi
3990: WHERE y.item_id = a.item_id
3991: AND y.organization_id = z.organization_id
3992: AND hoi.organization_id = z.organization_id

Line 4803: mtl_parameters z,

4799: (
4800: SELECT z.master_organization_id,
4801: y.inventory_item_id
4802: FROM ic_item_mst_b_mig y,
4803: mtl_parameters z,
4804: hr_organization_information hoi
4805: WHERE y.item_id = a.item_id
4806: AND y.organization_id = z.organization_id
4807: AND hoi.organization_id = z.organization_id

Line 6668: mtl_parameters d,

6664: e.ledger_id
6665: FROM gmf_fiscal_policies a,
6666: gl_plcy_mst b,
6667: gmf_legal_entities c,
6668: mtl_parameters d,
6669: gl_ledgers e
6670: WHERE a.legal_entity_id = b.legal_entity_id
6671: AND c.legal_entity_id = a.legal_entity_id
6672: AND d.organization_id(+) = c.legal_entity_id

Line 9959: ,mtl_parameters z /*B13612793*/

9955: AND a.co_code = b.co_code
9956: AND b.orgn_code = c.orgn_code
9957: AND nvl(c.subinventory_ind_flag, 'N') <> 'Y'
9958: )x
9959: ,mtl_parameters z /*B13612793*/
9960: WHERE x.organization_id = z.organization_id /*B13612793*/
9961: ;
9962:
9963: BEGIN

Line 10030: mtl_parameters z,

10026: = (
10027: SELECT z.master_organization_id,
10028: y.inventory_item_id
10029: FROM ic_item_mst_b_mig y,
10030: mtl_parameters z,
10031: hr_organization_information hoi
10032: WHERE y.item_id = a.item_id
10033: AND y.organization_id = z.organization_id
10034: AND hoi.organization_id = z.organization_id

Line 10752: mtl_parameters z,

10748: (
10749: SELECT z.master_organization_id,
10750: y.inventory_item_id
10751: FROM ic_item_mst_b_mig y,
10752: mtl_parameters z,
10753: hr_organization_information hoi
10754: WHERE y.item_id = a.item_id
10755: AND y.organization_id = z.organization_id
10756: AND hoi.organization_id = z.organization_id

Line 11411: mtl_parameters z,

11407: = (
11408: SELECT z.master_organization_id,
11409: y.inventory_item_id
11410: FROM ic_item_mst_b_mig y,
11411: mtl_parameters z,
11412: hr_organization_information hoi
11413: WHERE y.item_id = a.item_id
11414: AND y.organization_id = z.organization_id
11415: AND hoi.organization_id = z.organization_id

Line 11507: mtl_parameters z,

11503: = (
11504: SELECT z.master_organization_id,
11505: y.inventory_item_id
11506: FROM ic_item_mst_b_mig y,
11507: mtl_parameters z,
11508: hr_organization_information hoi,
11509: cm_rlup_ctl x
11510: WHERE y.item_id = a.item_id
11511: AND y.organization_id = z.organization_id