DBA Data[Home] [Help]

APPS.GMF_MIGRATION dependencies on MTL_PARAMETERS

Line 3965: mtl_parameters z,

3961: = (
3962: SELECT z.master_organization_id,
3963: y.inventory_item_id
3964: FROM ic_item_mst_b_mig y,
3965: mtl_parameters z,
3966: hr_organization_information hoi
3967: WHERE y.item_id = a.item_id
3968: AND y.organization_id = z.organization_id
3969: AND hoi.organization_id = z.organization_id

Line 4780: mtl_parameters z,

4776: (
4777: SELECT z.master_organization_id,
4778: y.inventory_item_id
4779: FROM ic_item_mst_b_mig y,
4780: mtl_parameters z,
4781: hr_organization_information hoi
4782: WHERE y.item_id = a.item_id
4783: AND y.organization_id = z.organization_id
4784: AND hoi.organization_id = z.organization_id

Line 6588: mtl_parameters d,

6584: e.ledger_id
6585: FROM gmf_fiscal_policies a,
6586: gl_plcy_mst b,
6587: gmf_legal_entities c,
6588: mtl_parameters d,
6589: gl_ledgers e
6590: WHERE a.legal_entity_id = b.legal_entity_id
6591: AND c.legal_entity_id = a.legal_entity_id
6592: AND d.organization_id(+) = c.legal_entity_id

Line 9703: mtl_parameters z,

9699: = (
9700: SELECT z.master_organization_id,
9701: y.inventory_item_id
9702: FROM ic_item_mst_b_mig y,
9703: mtl_parameters z,
9704: hr_organization_information hoi
9705: WHERE y.item_id = a.item_id
9706: AND y.organization_id = z.organization_id
9707: AND hoi.organization_id = z.organization_id

Line 10423: mtl_parameters z,

10419: (
10420: SELECT z.master_organization_id,
10421: y.inventory_item_id
10422: FROM ic_item_mst_b_mig y,
10423: mtl_parameters z,
10424: hr_organization_information hoi
10425: WHERE y.item_id = a.item_id
10426: AND y.organization_id = z.organization_id
10427: AND hoi.organization_id = z.organization_id

Line 11080: mtl_parameters z,

11076: = (
11077: SELECT z.master_organization_id,
11078: y.inventory_item_id
11079: FROM ic_item_mst_b_mig y,
11080: mtl_parameters z,
11081: hr_organization_information hoi
11082: WHERE y.item_id = a.item_id
11083: AND y.organization_id = z.organization_id
11084: AND hoi.organization_id = z.organization_id

Line 11176: mtl_parameters z,

11172: = (
11173: SELECT z.master_organization_id,
11174: y.inventory_item_id
11175: FROM ic_item_mst_b_mig y,
11176: mtl_parameters z,
11177: hr_organization_information hoi,
11178: cm_rlup_ctl x
11179: WHERE y.item_id = a.item_id
11180: AND y.organization_id = z.organization_id