APPS.GMF_CMCOMMON dependencies on CM_WHSE_ASC

Line 482: X_cost_organization_id cm_whse_asc.cost_organization_id%TYPE;

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

Line 509: FROM cm_whse_asc

505: v_trans_date IN DATE
506: )
507: IS
508: SELECT cost_ORGANIZATION_ID
509: FROM cm_whse_asc
510: WHERE ORGANIZATION_ID = V_ORGANIZATION_ID
511: AND eff_start_date <= v_trans_date
512: AND eff_end_date >= v_trans_date
513: AND delete_mark = 0;

Line 2499: FROM cm_whse_asc x

2495: (
2496: select nvl (
2497: (
2498: SELECT x.cost_organization_id
2499: FROM cm_whse_asc x
2500: WHERE x.organization_id = v_organization_id
2501: AND x.eff_start_date <= v_transaction_date
2502: AND x.eff_end_date >= v_transaction_date
2503: AND x.delete_mark = 0

Line 2534: FROM cm_whse_asc x

2530: (
2531: select nvl (
2532: (
2533: SELECT x.cost_organization_id
2534: FROM cm_whse_asc x
2535: WHERE x.organization_id = v_organization_id
2536: AND x.eff_start_date <= v_transaction_date
2537: AND x.eff_end_date >= v_transaction_date
2538: AND x.delete_mark = 0