eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMF_MIGRATION dependencies on SY_ORGN_MST

Line 1677: L_co_code sy_orgn_mst.co_code%TYPE;

1673: /************************
1674: * Local Variables *
1675: ************************/
1676:
1677: L_co_code sy_orgn_mst.co_code%TYPE;
1678:
1679: /****************
1680: * Cursors *
1681: ****************/

Line 1689: from sy_orgn_mst a,

1685: p_whse_code IN VARCHAR2
1686: )
1687: IS
1688: select a.co_code
1689: from sy_orgn_mst a,
1690: ic_whse_mst b
1691: where a.orgn_code = b.orgn_code
1692: and b.whse_code = p_whse_code;
1693:

Line 3093: sy_orgn_mst j,

3089: 1
3090: FROM cm_cldr_hdr_b g,
3091: cm_mthd_mst h,
3092: gl_plcy_mst i,
3093: sy_orgn_mst j,
3094: cm_rsrc_dtl k
3095: WHERE g.co_code IS NOT NULL
3096: AND j.orgn_code = k.orgn_code
3097: AND i.co_code = j.co_code

Line 3189: sy_orgn_mst j,

3185: 1
3186: FROM cm_cldr_hdr_b g,
3187: cm_mthd_mst h,
3188: gl_plcy_mst i,
3189: sy_orgn_mst j,
3190: cm_brdn_dtl k
3191: WHERE g.co_code IS NOT NULL
3192: AND j.orgn_code = k.orgn_code
3193: AND i.co_code = j.co_code

Line 3285: sy_orgn_mst j,

3281: 1
3282: FROM cm_cldr_hdr_b g,
3283: cm_mthd_mst h,
3284: gl_plcy_mst i,
3285: sy_orgn_mst j,
3286: cm_cmpt_dtl k,
3287: ic_whse_mst l
3288: WHERE g.co_code IS NOT NULL
3289: AND l.whse_code = k.whse_code

Line 3383: sy_orgn_mst j,

3379: 1
3380: FROM cm_cldr_hdr_b g,
3381: cm_mthd_mst h,
3382: gl_plcy_mst i,
3383: sy_orgn_mst j,
3384: cm_adjs_dtl k,
3385: ic_whse_mst l
3386: WHERE g.co_code IS NOT NULL
3387: AND l.whse_code = k.whse_code

Line 3902: FROM ic_whse_mst x, sy_orgn_mst y

3898: )
3899: = (
3900: SELECT DECODE(a.whse_code, null, DECODE(NVL(Y.INVENTORY_ORG_IND,'N'), 'Y', y.organization_id, NULL), DECODE(NVL(x.subinventory_ind_flag,'N'), 'Y', x.organization_id, x.mtl_organization_id)),
3901: DECODE(a.delete_mark, 1, a.delete_mark, DECODE(a.whse_code, null, DECODE(NVL(Y.INVENTORY_ORG_IND,'N'), 'Y', 0, 1), DECODE(NVL(x.subinventory_ind_flag,'N'), 'Y', 1, 0)))
3902: FROM ic_whse_mst x, sy_orgn_mst y
3903: WHERE x.whse_code = nvl(a.whse_code, x.whse_code)
3904: and y.orgn_code = DECODE(a.whse_code, NULL, a.orgn_code, x.orgn_code)
3905: AND ROWNUM = 1
3906: )

Line 6454: TYPE t_inventory_org_ind IS TABLE OF SY_ORGN_MST.INVENTORY_ORG_IND%TYPE INDEX BY BINARY_INTEGER;

6450: TYPE t_gl_product_line_cat_id IS TABLE OF GL_ACCT_MAP.GL_PRODUCT_LINE_CAT_ID%TYPE INDEX BY BINARY_INTEGER;
6451: TYPE t_line_type IS TABLE OF GL_ACCT_MAP.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
6452: TYPE t_ar_trx_type_id IS TABLE OF GL_ACCT_MAP.AR_TRX_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
6453: TYPE t_rowid IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
6454: TYPE t_inventory_org_ind IS TABLE OF SY_ORGN_MST.INVENTORY_ORG_IND%TYPE INDEX BY BINARY_INTEGER;
6455: TYPE t_organization_id IS TABLE OF SY_ORGN_MST.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
6456: TYPE t_mtl_organization_id IS TABLE OF IC_WHSE_MST.MTL_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
6457: TYPE t_subinventory_ind_flag IS TABLE OF IC_WHSE_MST.SUBINVENTORY_IND_FLAG%TYPE INDEX BY BINARY_INTEGER;
6458: TYPE t_acct_no IS TABLE OF GL_ACCT_MST.ACCT_NO%TYPE INDEX BY BINARY_INTEGER;

Line 6455: TYPE t_organization_id IS TABLE OF SY_ORGN_MST.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;

6451: TYPE t_line_type IS TABLE OF GL_ACCT_MAP.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
6452: TYPE t_ar_trx_type_id IS TABLE OF GL_ACCT_MAP.AR_TRX_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
6453: TYPE t_rowid IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
6454: TYPE t_inventory_org_ind IS TABLE OF SY_ORGN_MST.INVENTORY_ORG_IND%TYPE INDEX BY BINARY_INTEGER;
6455: TYPE t_organization_id IS TABLE OF SY_ORGN_MST.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
6456: TYPE t_mtl_organization_id IS TABLE OF IC_WHSE_MST.MTL_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
6457: TYPE t_subinventory_ind_flag IS TABLE OF IC_WHSE_MST.SUBINVENTORY_IND_FLAG%TYPE INDEX BY BINARY_INTEGER;
6458: TYPE t_acct_no IS TABLE OF GL_ACCT_MST.ACCT_NO%TYPE INDEX BY BINARY_INTEGER;
6459: TYPE t_source_type IS TABLE OF GL_ACCT_MAP.SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 6649: sy_orgn_mst c,

6645: b.acctg_unit_no,
6646: a.accu_map_id
6647: FROM gl_accu_map a,
6648: gl_accu_mst b,
6649: sy_orgn_mst c,
6650: ic_whse_mst d
6651: WHERE a.co_code = p_co_code
6652: AND b.acctg_unit_id = a.acctg_unit_id
6653: AND c.orgn_code(+) = a.orgn_code

Line 7710: sy_orgn_mst c,

7706: BEGIN
7707: EXECUTE IMMEDIATE X_sqlcolumns ||
7708: ' FROM gl_acct_map a,
7709: gl_acct_mst b,
7710: sy_orgn_mst c,
7711: ic_whse_mst d '
7712: ||
7713: X_sqlwhere
7714: ||

Line 8893: FROM sy_orgn_mst a,

8889: b.period_end_date curr_period_end_date,
8890: c.period_id prior_period_id,
8891: c.period_end_date prior_period_end_date,
8892: c.closed_period_ind prior_period_closed_ind
8893: FROM sy_orgn_mst a,
8894: ic_cldr_dtl b,
8895: ic_cldr_dtl c,
8896: org_acct_periods d,
8897: hr_organization_information hoi,

Line 9628: sy_orgn_mst b,

9624: FROM (
9625: SELECT a.item_id,
9626: decode(NVL(c.subinventory_ind_flag,'N'), 'Y', c.organization_id, c.mtl_organization_id) organization_id
9627: FROM cm_cmpt_mtl a,
9628: sy_orgn_mst b,
9629: ic_whse_mst c
9630: WHERE a.item_id IS NOT NULL
9631: AND a.co_code = b.co_code
9632: AND b.orgn_code = c.orgn_code

Line 10400: FROM gl_plcy_mst z, sy_orgn_mst w

10396: a.delete_mark
10397: )
10398: = (
10399: SELECT w.organization_id, z.legal_entity_id, decode(a.delete_mark, 1, 1, decode(nvl(w.inventory_org_ind, 'N'), 'Y', 0, 1))
10400: FROM gl_plcy_mst z, sy_orgn_mst w
10401: WHERE w.orgn_code = a.orgn_code
10402: AND w.co_code = z.co_code
10403: ),
10404: a.source_organization_id = (

Line 10660: sy_orgn_mst b,

10656: UNION
10657: SELECT a.item_id,
10658: DECODE(NVL(c.subinventory_ind_flag,'N'), 'Y', c.organization_id, c.mtl_organization_id) organization_id
10659: FROM gmf_lot_costed_items a,
10660: sy_orgn_mst b,
10661: ic_whse_mst c
10662: WHERE a.item_id IS NOT NULL
10663: AND a.co_code = b.co_Code
10664: AND b.orgn_code = c.orgn_code

Line 11796: sy_orgn_mst b,

11792: DECODE(COUNT(f.cost_whse_code), 0, 'N', 'Y') same_plant_cost_warehouse,
11793: DECODE(SUM(DECODE(f.cost_whse_code, NULL, 0, DECODE(NVL(c.subinventory_ind_flag, 'N'), 'N', 0, 1))), 0, 'N', 'Y') cost_whse_is_subinv,
11794: DECODE(COUNT(e.whse_code), 0, 'N', 'Y') inv_warehouse
11795: FROM ic_whse_mst a,
11796: sy_orgn_mst b,
11797: ic_whse_mst c,
11798: cm_whse_asc d,
11799: cm_whse_asc e,
11800: cm_whse_asc f