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 3907: FROM ic_whse_mst x, sy_orgn_mst y

3903: )
3904: = (
3905: 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)),
3906: 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)))
3907: FROM ic_whse_mst x, sy_orgn_mst y
3908: WHERE x.whse_code = nvl(a.whse_code, x.whse_code)
3909: and y.orgn_code = DECODE(a.whse_code, NULL, a.orgn_code, x.orgn_code)
3910: AND ROWNUM = 1
3911: )*/

Line 3928: FROM ic_whse_mst x, sy_orgn_mst y

3924: )
3925: = (
3926: 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)),
3927: 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)))
3928: FROM ic_whse_mst x, sy_orgn_mst y
3929: WHERE x.whse_code = nvl(a.whse_code, x.whse_code)
3930: and y.orgn_code = DECODE(a.whse_code, NULL, a.orgn_code, x.orgn_code)
3931: AND ROWNUM = 1
3932: )

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

6530: TYPE t_gl_product_line_cat_id IS TABLE OF GL_ACCT_MAP.GL_PRODUCT_LINE_CAT_ID%TYPE INDEX BY BINARY_INTEGER;
6531: TYPE t_line_type IS TABLE OF GL_ACCT_MAP.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
6532: TYPE t_ar_trx_type_id IS TABLE OF GL_ACCT_MAP.AR_TRX_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
6533: TYPE t_rowid IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
6534: TYPE t_inventory_org_ind IS TABLE OF SY_ORGN_MST.INVENTORY_ORG_IND%TYPE INDEX BY BINARY_INTEGER;
6535: TYPE t_organization_id IS TABLE OF SY_ORGN_MST.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
6536: TYPE t_mtl_organization_id IS TABLE OF IC_WHSE_MST.MTL_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
6537: TYPE t_subinventory_ind_flag IS TABLE OF IC_WHSE_MST.SUBINVENTORY_IND_FLAG%TYPE INDEX BY BINARY_INTEGER;
6538: TYPE t_acct_no IS TABLE OF GL_ACCT_MST.ACCT_NO%TYPE INDEX BY BINARY_INTEGER;

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

6531: TYPE t_line_type IS TABLE OF GL_ACCT_MAP.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
6532: TYPE t_ar_trx_type_id IS TABLE OF GL_ACCT_MAP.AR_TRX_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
6533: TYPE t_rowid IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
6534: TYPE t_inventory_org_ind IS TABLE OF SY_ORGN_MST.INVENTORY_ORG_IND%TYPE INDEX BY BINARY_INTEGER;
6535: TYPE t_organization_id IS TABLE OF SY_ORGN_MST.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
6536: TYPE t_mtl_organization_id IS TABLE OF IC_WHSE_MST.MTL_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
6537: TYPE t_subinventory_ind_flag IS TABLE OF IC_WHSE_MST.SUBINVENTORY_IND_FLAG%TYPE INDEX BY BINARY_INTEGER;
6538: TYPE t_acct_no IS TABLE OF GL_ACCT_MST.ACCT_NO%TYPE INDEX BY BINARY_INTEGER;
6539: TYPE t_source_type IS TABLE OF GL_ACCT_MAP.SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 6729: sy_orgn_mst c,

6725: b.acctg_unit_no,
6726: a.accu_map_id
6727: FROM gl_accu_map a,
6728: gl_accu_mst b,
6729: sy_orgn_mst c,
6730: ic_whse_mst d
6731: WHERE a.co_code = p_co_code
6732: AND b.acctg_unit_id = a.acctg_unit_id
6733: AND c.orgn_code(+) = a.orgn_code

Line 7797: sy_orgn_mst c,

7793: BEGIN
7794: EXECUTE IMMEDIATE X_sqlcolumns ||
7795: ' FROM gl_acct_map a,
7796: gl_acct_mst b,
7797: sy_orgn_mst c,
7798: ic_whse_mst d '
7799: ||
7800: X_sqlwhere
7801: ||

Line 8952: * ic_cldr_dtl.orgn_code to sy_orgn_mst.co_code, so that it *

8948: * witin the company. In 11i, as OPM inventory calendar periods *
8949: * (i.e ic_cldr_dtl) are maintained at Company level (and not *
8950: * at warehouse/orgn level), ic_cldr_dtl.orgn_code points to *
8951: * co_code. Hence Modified CURSOR cur_orgn_periods to join *
8952: * ic_cldr_dtl.orgn_code to sy_orgn_mst.co_code, so that it *
8953: * identifies all the organizations under the company and thus *
8954: * fetches all the warehouses under that company. *
8955: * *
8956: * 11-Apr-2012 Uday Phadtare Bug 13942118. *

Line 9003: FROM sy_orgn_mst a,

8999: c.period_end_date prior_period_end_date,
9000: c.closed_period_ind prior_period_closed_ind,
9001: c.fiscal_year prior_fiscal_year, /* Bug 13045530 */
9002: c.period prior_period /* Bug 13045530 */
9003: FROM sy_orgn_mst a,
9004: ic_cldr_dtl b,
9005: ic_cldr_dtl c,
9006: org_acct_periods d,
9007: hr_organization_information hoi,

Line 9952: sy_orgn_mst b,

9948: FROM (
9949: SELECT a.item_id,
9950: decode(NVL(c.subinventory_ind_flag,'N'), 'Y', c.organization_id, c.mtl_organization_id) organization_id
9951: FROM cm_cmpt_mtl a,
9952: sy_orgn_mst b,
9953: ic_whse_mst c
9954: WHERE a.item_id IS NOT NULL
9955: AND a.co_code = b.co_code
9956: AND b.orgn_code = c.orgn_code

Line 10729: FROM gl_plcy_mst z, sy_orgn_mst w

10725: a.delete_mark
10726: )
10727: = (
10728: SELECT w.organization_id, z.legal_entity_id, decode(a.delete_mark, 1, 1, decode(nvl(w.inventory_org_ind, 'N'), 'Y', 0, 1))
10729: FROM gl_plcy_mst z, sy_orgn_mst w
10730: WHERE w.orgn_code = a.orgn_code
10731: AND w.co_code = z.co_code
10732: ),
10733: a.source_organization_id = (

Line 10990: sy_orgn_mst b,

10986: UNION
10987: SELECT a.item_id,
10988: DECODE(NVL(c.subinventory_ind_flag,'N'), 'Y', c.organization_id, c.mtl_organization_id) organization_id
10989: FROM gmf_lot_costed_items a,
10990: sy_orgn_mst b,
10991: ic_whse_mst c
10992: WHERE a.item_id IS NOT NULL
10993: AND a.co_code = b.co_Code
10994: AND b.orgn_code = c.orgn_code

Line 12127: sy_orgn_mst b,

12123: DECODE(COUNT(f.cost_whse_code), 0, 'N', 'Y') same_plant_cost_warehouse,
12124: 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,
12125: DECODE(COUNT(e.whse_code), 0, 'N', 'Y') inv_warehouse
12126: FROM ic_whse_mst a,
12127: sy_orgn_mst b,
12128: ic_whse_mst c,
12129: cm_whse_asc d,
12130: cm_whse_asc e,
12131: cm_whse_asc f