APPS.GMF_CMCOMMON dependencies on CM_WHSE_ASC

Line 478: X_cost_organization_id cm_whse_asc.cost_organization_id%TYPE;

474: l_api_name CONSTANT VARCHAR2(30) := 'Get_Process_Item_Cost' ;
475: l_api_version CONSTANT NUMBER := 1.0 ;
476:
477: X_itemcost_id gl_item_cst.itemcost_id%TYPE;
478: X_cost_organization_id cm_whse_asc.cost_organization_id%TYPE;
479: X_no_recs NUMBER(10);
480: i INTEGER;
481: p_cost_type_id cm_mthd_mst.cost_type_id%type;
482: l_cost_type cm_mthd_mst.cost_type%type;

Line 505: FROM cm_whse_asc

501: v_trans_date IN DATE
502: )
503: IS
504: SELECT cost_ORGANIZATION_ID
505: FROM cm_whse_asc
506: WHERE ORGANIZATION_ID = V_ORGANIZATION_ID
507: AND eff_start_date <= v_trans_date
508: AND eff_end_date >= v_trans_date
509: AND delete_mark = 0;

Line 2321: FROM cm_whse_asc x

2317: (
2318: select nvl (
2319: (
2320: SELECT x.cost_organization_id
2321: FROM cm_whse_asc x
2322: WHERE x.organization_id = v_organization_id
2323: AND x.eff_start_date <= v_transaction_date
2324: AND x.eff_end_date >= v_transaction_date
2325: AND x.delete_mark = 0

Line 2356: FROM cm_whse_asc x

2352: (
2353: select nvl (
2354: (
2355: SELECT x.cost_organization_id
2356: FROM cm_whse_asc x
2357: WHERE x.organization_id = v_organization_id
2358: AND x.eff_start_date <= v_transaction_date
2359: AND x.eff_end_date >= v_transaction_date
2360: AND x.delete_mark = 0