APPS.GMF_LOT_COSTING_PUB dependencies on GMF_PERIOD_STATUSES

Line 509: period_id gmf_period_statuses.period_id%TYPE

505: /* Bug 13386258-VC End */
506:
507: TYPE period_typ IS RECORD
508: (
509: period_id gmf_period_statuses.period_id%TYPE
510: , final_date gmf_period_statuses.CALENDAR_CODE%TYPE
511: , start_date gmf_period_statuses.start_date%TYPE
512: , end_date gmf_period_statuses.end_date%TYPE
513: );

Line 510: , final_date gmf_period_statuses.CALENDAR_CODE%TYPE

506:
507: TYPE period_typ IS RECORD
508: (
509: period_id gmf_period_statuses.period_id%TYPE
510: , final_date gmf_period_statuses.CALENDAR_CODE%TYPE
511: , start_date gmf_period_statuses.start_date%TYPE
512: , end_date gmf_period_statuses.end_date%TYPE
513: );
514:

Line 511: , start_date gmf_period_statuses.start_date%TYPE

507: TYPE period_typ IS RECORD
508: (
509: period_id gmf_period_statuses.period_id%TYPE
510: , final_date gmf_period_statuses.CALENDAR_CODE%TYPE
511: , start_date gmf_period_statuses.start_date%TYPE
512: , end_date gmf_period_statuses.end_date%TYPE
513: );
514:
515: TYPE period_tbl IS TABLE OF period_typ INDEX BY VARCHAR2(30);

Line 512: , end_date gmf_period_statuses.end_date%TYPE

508: (
509: period_id gmf_period_statuses.period_id%TYPE
510: , final_date gmf_period_statuses.CALENDAR_CODE%TYPE
511: , start_date gmf_period_statuses.start_date%TYPE
512: , end_date gmf_period_statuses.end_date%TYPE
513: );
514:
515: TYPE period_tbl IS TABLE OF period_typ INDEX BY VARCHAR2(30);
516: period_tab period_tbl;

Line 523: period_id gmf_period_statuses.period_id%TYPE ,

519: TYPE Alter_cost_typ IS RECORD
520: (
521: inventory_item_id mtl_system_items.Inventory_item_id%type ,
522: organization_id mtl_parameters.organization_id%TYPE ,
523: period_id gmf_period_statuses.period_id%TYPE ,
524: cost_details SYSTEM.gmf_cost_tab ,
525: total_cost NUMBER
526: ) ;
527: TYPE Alter_cost_tbl IS TABLE OF Alter_cost_typ INDEX BY VARCHAR2(90);

Line 1374: gmf_period_statuses gps

1370: )
1371: IS
1372: SELECT sum(cst.cmpnt_cost)
1373: FROM cm_cmpt_dtl cst,
1374: gmf_period_statuses gps
1375: WHERE gps.legal_entity_id = p_le_id
1376: AND gps.cost_type_id = p_cost_type_id
1377: AND gps.start_date <= p_date
1378: AND gps.end_date >= p_date

Line 1453: gmf_period_statuses gps

1449: cst.cost_analysis_code,
1450: 0 cost_level,
1451: SUM(cst.cmpnt_cost) cmpnt_cost
1452: FROM cm_cmpt_dtl cst,
1453: gmf_period_statuses gps
1454: WHERE gps.legal_entity_id = p_le_id
1455: AND gps.cost_type_id = p_cost_type_id
1456: AND gps.start_date <= p_date
1457: AND gps.end_date >= p_date

Line 1504: ,gmf_period_statuses gps

1500: 0,
1501: cst.nominal_cost,
1502: 0
1503: FROM cm_rsrc_dtl cst
1504: ,gmf_period_statuses gps
1505: ,gme_batch_step_resources gbsr
1506: WHERE gps.legal_entity_id = p_le_id
1507: AND gps.cost_type_id = p_cost_type_id
1508: AND gps.start_date <= p_date

Line 1650: gmf_period_statuses gps

1646: )
1647: IS
1648: SELECT cst.nominal_cost
1649: FROM cm_rsrc_dtl cst,
1650: gmf_period_statuses gps
1651: WHERE gps.legal_entity_id = p_le_id
1652: AND gps.cost_type_id = p_cost_type_id
1653: AND gps.start_date <= p_date
1654: AND gps.end_date >= p_date

Line 10042: FROM gmf_period_statuses c,

10038: SELECT period_id,
10039: TO_CHAR( (TRUNC(start_date) + (just_a_column -1 )),'J') final_date,
10040: TRUNC(start_date) start_date,
10041: TRUNC(end_date) end_date
10042: FROM gmf_period_statuses c,
10043: (SELECT ROWNUM just_a_column
10044: FROM dual
10045: CONNECT BY LEVEL <= 7400 )
10046: WHERE cost_type_id = l_default_cost_type_id