eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMF_LOT_COSTING_PUB dependencies on GMF_COST_TAB

Line 524: cost_details SYSTEM.gmf_cost_tab ,

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);
528: Alter_cost_tab Alter_cost_tbl;

Line 784: ) AS SYSTEM.gmf_cost_tab

780: , CAST
781: ( MULTISET
782: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)
783: FROM DUAL
784: ) AS SYSTEM.gmf_cost_tab
785: )
786: , CAST
787: ( MULTISET
788: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)

Line 790: ) AS SYSTEM.gmf_cost_tab

786: , CAST
787: ( MULTISET
788: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)
789: FROM DUAL
790: ) AS SYSTEM.gmf_cost_tab
791: )
792: , CAST
793: ( MULTISET
794: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)

Line 796: ) AS SYSTEM.gmf_cost_tab

792: , CAST
793: ( MULTISET
794: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)
795: FROM DUAL
796: ) AS SYSTEM.gmf_cost_tab
797: )
798: , NULL, NULL
799: , CAST
800: ( MULTISET

Line 831: ) AS SYSTEM.gmf_cost_tab

827: , CAST
828: ( MULTISET
829: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)
830: FROM DUAL
831: ) AS SYSTEM.gmf_cost_tab
832: )
833: , CAST
834: ( MULTISET
835: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)

Line 837: ) AS SYSTEM.gmf_cost_tab

833: , CAST
834: ( MULTISET
835: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)
836: FROM DUAL
837: ) AS SYSTEM.gmf_cost_tab
838: )
839: , CAST
840: ( MULTISET
841: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)

Line 843: ) AS SYSTEM.gmf_cost_tab

839: , CAST
840: ( MULTISET
841: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)
842: FROM DUAL
843: ) AS SYSTEM.gmf_cost_tab
844: )
845: , NULL, NULL
846: , CAST
847: ( MULTISET

Line 881: ) AS SYSTEM.gmf_cost_tab

877: , CAST
878: ( MULTISET
879: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)
880: FROM DUAL
881: ) AS SYSTEM.gmf_cost_tab
882: )
883: , CAST
884: ( MULTISET
885: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)

Line 887: ) AS SYSTEM.gmf_cost_tab

883: , CAST
884: ( MULTISET
885: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)
886: FROM DUAL
887: ) AS SYSTEM.gmf_cost_tab
888: )
889: , CAST
890: ( MULTISET
891: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)

Line 893: ) AS SYSTEM.gmf_cost_tab

889: , CAST
890: ( MULTISET
891: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)
892: FROM DUAL
893: ) AS SYSTEM.gmf_cost_tab
894: )
895: , NULL, NULL
896: , CAST
897: ( MULTISET

Line 922: FROM DUAL) AS SYSTEM.gmf_cost_tab

918: gbs.actual_step_qty,
919: gbs.step_qty_um,
920: 0,
921: CAST (MULTISET (SELECT SYSTEM.gmf_cost_type (0, ' ', 0, 0, 0)
922: FROM DUAL) AS SYSTEM.gmf_cost_tab
923: ),
924: CAST (MULTISET (SELECT SYSTEM.gmf_cost_type (0, ' ', 0, 0, 0)
925: FROM DUAL) AS SYSTEM.gmf_cost_tab
926: ),

Line 925: FROM DUAL) AS SYSTEM.gmf_cost_tab

921: CAST (MULTISET (SELECT SYSTEM.gmf_cost_type (0, ' ', 0, 0, 0)
922: FROM DUAL) AS SYSTEM.gmf_cost_tab
923: ),
924: CAST (MULTISET (SELECT SYSTEM.gmf_cost_type (0, ' ', 0, 0, 0)
925: FROM DUAL) AS SYSTEM.gmf_cost_tab
926: ),
927: CAST (MULTISET (SELECT SYSTEM.gmf_cost_type (0, ' ', 0, 0, 0)
928: FROM DUAL) AS SYSTEM.gmf_cost_tab
929: ),

Line 928: FROM DUAL) AS SYSTEM.gmf_cost_tab

924: CAST (MULTISET (SELECT SYSTEM.gmf_cost_type (0, ' ', 0, 0, 0)
925: FROM DUAL) AS SYSTEM.gmf_cost_tab
926: ),
927: CAST (MULTISET (SELECT SYSTEM.gmf_cost_type (0, ' ', 0, 0, 0)
928: FROM DUAL) AS SYSTEM.gmf_cost_tab
929: ),
930: NULL,
931: NULL,
932: CAST

Line 996: FROM DUAL) AS SYSTEM.gmf_cost_tab

992: gmd.plan_qty,
993: gmd.actual_qty,
994: gmd.dtl_um,
995: CAST (MULTISET (SELECT SYSTEM.gmf_cost_type (0, ' ', 0, 0, 0)
996: FROM DUAL) AS SYSTEM.gmf_cost_tab
997: ), -- Bug 7317270,
998: gmd.cost_alloc
999: )
1000: FROM mtl_system_items_b iimb,

Line 1067: FROM DUAL) AS SYSTEM.gmf_cost_tab

1063: plan_qty,
1064: actual_qty,
1065: dtl_um,
1066: CAST (MULTISET (SELECT SYSTEM.gmf_cost_type (0, ' ', 0, 0, 0)
1067: FROM DUAL) AS SYSTEM.gmf_cost_tab
1068: ), -- Bug 7317270
1069: cost_alloc
1070: )
1071: FROM (

Line 1171: FROM DUAL) AS SYSTEM.gmf_cost_tab

1167: gmd.plan_qty,
1168: gmd.actual_qty,
1169: gmd.dtl_um,
1170: CAST (MULTISET (SELECT SYSTEM.gmf_cost_type (0, ' ', 0, 0, 0)
1171: FROM DUAL) AS SYSTEM.gmf_cost_tab
1172: ), -- Bug 7317270
1173: gmd.cost_alloc
1174: )
1175: FROM mtl_system_items_b iimb,

Line 1216: FROM DUAL) AS SYSTEM.gmf_cost_tab

1212: gme.plan_qty,
1213: gme.actual_qty,
1214: gme.dtl_um,
1215: CAST (MULTISET (SELECT SYSTEM.gmf_cost_type (0, ' ', 0, 0, 0)
1216: FROM DUAL) AS SYSTEM.gmf_cost_tab
1217: ), -- Bug 7317270
1218: gme.cost_alloc
1219: )
1220: FROM mtl_system_items_b iimb,

Line 1280: FROM DUAL) AS SYSTEM.gmf_cost_tab

1276: grt.trans_qty_um,
1277: grt.trans_date,
1278: 0,
1279: CAST (MULTISET (SELECT SYSTEM.gmf_cost_type (0, ' ', 0, 0, 0)
1280: FROM DUAL) AS SYSTEM.gmf_cost_tab
1281: ) -- Bug 7317270
1282: )
1283: FROM gme_resource_txns grt,
1284: gme_batch_step_resources gbsr

Line 8772: l_cost_table SYSTEM.gmf_cost_tab := new SYSTEM.gmf_cost_tab();

8768: x_new_cost_tab OUT NOCOPY l_cost_tab_type,
8769: x_total_cost OUT NOCOPY NUMBER
8770: )
8771: IS
8772: l_cost_table SYSTEM.gmf_cost_tab := new SYSTEM.gmf_cost_tab();
8773: CURSOR final_cmpnt_cur IS
8774: SELECT SYSTEM.gmf_cost_type(nct.cost_cmpntcls_id,
8775: nct.cost_analysis_code,
8776: nct.cost_level,

Line 8779: FROM TABLE ( cast(l_cost_Table AS SYSTEM.gmf_cost_tab) ) nct

8775: nct.cost_analysis_code,
8776: nct.cost_level,
8777: sum(nct.component_cost),
8778: nct.burden_ind)
8779: FROM TABLE ( cast(l_cost_Table AS SYSTEM.gmf_cost_tab) ) nct
8780: GROUP BY nct.cost_cmpntcls_id,nct.cost_analysis_code,nct.cost_level,nct.burden_ind;
8781:
8782: procedure_name VARCHAR2(100);
8783:

Line 8807: FROM TABLE ( CAST(l_cost_table AS SYSTEM.gmf_cost_tab) ) nct;

8803:
8804:
8805: SELECT SUM(nct.component_cost)
8806: INTO x_total_cost
8807: FROM TABLE ( CAST(l_cost_table AS SYSTEM.gmf_cost_tab) ) nct;
8808:
8809: IF l_debug_level >= l_debug_level_high THEN
8810: fnd_file.put_line(fnd_file.log,'After weighted average new_cost_tab is:');
8811: FOR k IN 1 .. new_cost_tab.COUNT