DBA Data[Home] [Help]

APPS.PMI_COST_ANALZ_PACK dependencies on SY_ORGN_MST

Line 24: sy_orgn_mst o,

20: IS
21: SELECT d.calendar_code, d.period_code
22: FROM cm_cldr_dtl d,
23: cm_cldr_hdr h,
24: sy_orgn_mst o,
25: ic_whse_mst w
26: WHERE
27: w.whse_code = cost_whse_v
28: AND w.orgn_code = o.orgn_code

Line 110: co_code_vi IN sy_orgn_mst.co_code%TYPE,

106: END gmca_get_cost;
107:
108: FUNCTION gmca_get_perbal(
109: tr_date_vi IN DATE,
110: co_code_vi IN sy_orgn_mst.co_code%TYPE,
111: whse_code_vi IN ic_perd_bal.whse_code%TYPE,
112: item_id_vi IN ic_perd_bal.item_id%TYPE)
113: RETURN NUMBER
114: IS

Line 118: co_code_vi IN sy_orgn_mst.co_code%TYPE,

114: IS
115: period_balance_v NUMBER;
116: CURSOR get_perbal_cur(
117: tr_date_vi IN DATE,
118: co_code_vi IN sy_orgn_mst.co_code%TYPE,
119: whse_code_vi IN ic_perd_bal.whse_code%TYPE,
120: item_id_vi IN ic_perd_bal.item_id%TYPE)
121: IS
122:

Line 388: sy_orgn_mst o,

384: SELECT d.calendar_code, d.period_code
385: INTO cost_calendar_v, cost_period_v
386: FROM cm_cldr_dtl d,
387: cm_cldr_hdr h,
388: sy_orgn_mst o,
389: ic_whse_mst w
390: WHERE
391: w.whse_code = cost_whse_v
392: AND w.orgn_code = o.orgn_code

Line 984: sy_orgn_mst o,

980: IS
981: SELECT base_currency_code
982: FROM
983: gl_plcy_mst p,
984: sy_orgn_mst o,
985: ic_whse_mst w
986: WHERE
987: w.whse_code = whse_code_vi
988: AND w.orgn_code = o.orgn_code