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 620: ) AS SYSTEM.gmf_cost_tab

616: , CAST
617: ( MULTISET
618: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)
619: FROM DUAL
620: ) AS SYSTEM.gmf_cost_tab
621: )
622: , CAST
623: ( MULTISET
624: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)

Line 626: ) AS SYSTEM.gmf_cost_tab

622: , CAST
623: ( MULTISET
624: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)
625: FROM DUAL
626: ) AS SYSTEM.gmf_cost_tab
627: )
628: , CAST
629: ( MULTISET
630: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)

Line 632: ) AS SYSTEM.gmf_cost_tab

628: , CAST
629: ( MULTISET
630: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)
631: FROM DUAL
632: ) AS SYSTEM.gmf_cost_tab
633: )
634: , NULL, NULL
635: , CAST
636: ( MULTISET

Line 667: ) AS SYSTEM.gmf_cost_tab

663: , CAST
664: ( MULTISET
665: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)
666: FROM DUAL
667: ) AS SYSTEM.gmf_cost_tab
668: )
669: , CAST
670: ( MULTISET
671: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)

Line 673: ) AS SYSTEM.gmf_cost_tab

669: , CAST
670: ( MULTISET
671: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)
672: FROM DUAL
673: ) AS SYSTEM.gmf_cost_tab
674: )
675: , CAST
676: ( MULTISET
677: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)

Line 679: ) AS SYSTEM.gmf_cost_tab

675: , CAST
676: ( MULTISET
677: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)
678: FROM DUAL
679: ) AS SYSTEM.gmf_cost_tab
680: )
681: , NULL, NULL
682: , CAST
683: ( MULTISET

Line 717: ) AS SYSTEM.gmf_cost_tab

713: , CAST
714: ( MULTISET
715: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)
716: FROM DUAL
717: ) AS SYSTEM.gmf_cost_tab
718: )
719: , CAST
720: ( MULTISET
721: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)

Line 723: ) AS SYSTEM.gmf_cost_tab

719: , CAST
720: ( MULTISET
721: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)
722: FROM DUAL
723: ) AS SYSTEM.gmf_cost_tab
724: )
725: , CAST
726: ( MULTISET
727: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)

Line 729: ) AS SYSTEM.gmf_cost_tab

725: , CAST
726: ( MULTISET
727: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)
728: FROM DUAL
729: ) AS SYSTEM.gmf_cost_tab
730: )
731: , NULL, NULL
732: , CAST
733: ( MULTISET

Line 758: FROM DUAL) AS SYSTEM.gmf_cost_tab

754: gbs.actual_step_qty,
755: gbs.step_qty_um,
756: 0,
757: CAST (MULTISET (SELECT SYSTEM.gmf_cost_type (0, ' ', 0, 0, 0)
758: FROM DUAL) AS SYSTEM.gmf_cost_tab
759: ),
760: CAST (MULTISET (SELECT SYSTEM.gmf_cost_type (0, ' ', 0, 0, 0)
761: FROM DUAL) AS SYSTEM.gmf_cost_tab
762: ),

Line 761: FROM DUAL) AS SYSTEM.gmf_cost_tab

757: CAST (MULTISET (SELECT SYSTEM.gmf_cost_type (0, ' ', 0, 0, 0)
758: FROM DUAL) AS SYSTEM.gmf_cost_tab
759: ),
760: CAST (MULTISET (SELECT SYSTEM.gmf_cost_type (0, ' ', 0, 0, 0)
761: FROM DUAL) AS SYSTEM.gmf_cost_tab
762: ),
763: CAST (MULTISET (SELECT SYSTEM.gmf_cost_type (0, ' ', 0, 0, 0)
764: FROM DUAL) AS SYSTEM.gmf_cost_tab
765: ),

Line 764: FROM DUAL) AS SYSTEM.gmf_cost_tab

760: CAST (MULTISET (SELECT SYSTEM.gmf_cost_type (0, ' ', 0, 0, 0)
761: FROM DUAL) AS SYSTEM.gmf_cost_tab
762: ),
763: CAST (MULTISET (SELECT SYSTEM.gmf_cost_type (0, ' ', 0, 0, 0)
764: FROM DUAL) AS SYSTEM.gmf_cost_tab
765: ),
766: NULL,
767: NULL,
768: CAST

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

7128: x_new_cost_tab OUT NOCOPY l_cost_tab_type,
7129: x_total_cost OUT NOCOPY NUMBER
7130: )
7131: IS
7132: l_cost_table SYSTEM.gmf_cost_tab := new SYSTEM.gmf_cost_tab();
7133: CURSOR final_cmpnt_cur IS
7134: SELECT SYSTEM.gmf_cost_type(nct.cost_cmpntcls_id,
7135: nct.cost_analysis_code,
7136: nct.cost_level,

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

7135: nct.cost_analysis_code,
7136: nct.cost_level,
7137: sum(nct.component_cost),
7138: nct.burden_ind)
7139: FROM TABLE ( cast(l_cost_Table AS SYSTEM.gmf_cost_tab) ) nct
7140: GROUP BY nct.cost_cmpntcls_id,nct.cost_analysis_code,nct.cost_level,nct.burden_ind;
7141:
7142: procedure_name VARCHAR2(100);
7143:

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

7165:
7166:
7167: SELECT SUM(nct.component_cost)
7168: INTO x_total_cost
7169: FROM TABLE ( CAST(l_cost_table AS SYSTEM.gmf_cost_tab) ) nct;
7170:
7171: IF l_debug_level >= l_debug_level_high
7172: THEN
7173: fnd_file.put_line(fnd_file.log,'After weighted average new_cost_tab is:');