DBA Data[Home] [Help]

APPS.GML_PO_GLDIST dependencies on IC_WHSE_MST

Line 32: FROM ic_whse_mst

28:
29: /* Cursor for getting orgn. for a particular whse_code.*/
30: CURSOR Cur_orgn_for_whse IS
31: SELECT orgn_code
32: FROM ic_whse_mst
33: WHERE whse_code = GML_PO_GLDIST.P_to_whse;
34:
35: /* Cursor for getting std_act_ind, exp_booked_ind and aqui_cost_ind*/
36: /* for a particular event code and source_code.*/

Line 238: FROM ic_whse_mst

234: PROCEDURE calc_dist_amount AS
235:
236: CURSOR Cur_orgn_for_whse IS
237: SELECT orgn_code
238: FROM ic_whse_mst
239: WHERE whse_code = GML_PO_GLDIST.P_to_whse;
240:
241: CURSOR Cur_get_ind_set IS
242: SELECT std_actual_ind , exp_booked_ind ,

Line 433: FROM sy_orgn_mst mst, ic_whse_mst ic

429:
430: /* RVK B1394532 */
431: CURSOR Cur_whse_co_code IS
432: SELECT mst.co_code, mst.orgn_code
433: FROM sy_orgn_mst mst, ic_whse_mst ic
434: WHERE ic.whse_code = v_to_whse and
435: mst.orgn_code = ic.orgn_code;
436:
437: CURSOR Cur_acctg_unit_id IS

Line 809: FROM ic_whse_mst

805: acct_ttl_type = P_acct_ttl_num;
806:
807: CURSOR Cur_whse_orgn_code IS
808: SELECT orgn_code
809: FROM ic_whse_mst
810: WHERE whse_code = P_to_whse;
811:
812: /* RVK B1394532 */
813: CURSOR Cur_acctg_unit_id (vc_orgn_code VARCHAR2) IS

Line 1311: FROM ic_whse_mst

1307: AND e.delete_mark = 0;
1308:
1309: CURSOR cur_get_orgn_code IS
1310: SELECT orgn_code
1311: FROM ic_whse_mst
1312: WHERE whse_code = v_to_whse
1313: AND delete_mark = 0;
1314:
1315: x_po_whse_orgn VARCHAR2(4);