APPS.CSTPCOIC dependencies on CST_ITEM_CST_DTLS_INTERFACE

Line 772: * Copy over columns into CST_ITEM_CST_DTLS_INTERFACE

768: RETURN( 1 );
769: END IF;
770:
771: /*
772: * Copy over columns into CST_ITEM_CST_DTLS_INTERFACE
773: * from CST_ITEM_COST_DETAILS
774: *
775: * CST_ITEM_COST_DETAILS ==> CST_ITEM_CST_DTLS_INTERFACE
776: */

Line 775: * CST_ITEM_COST_DETAILS ==> CST_ITEM_CST_DTLS_INTERFACE

771: /*
772: * Copy over columns into CST_ITEM_CST_DTLS_INTERFACE
773: * from CST_ITEM_COST_DETAILS
774: *
775: * CST_ITEM_COST_DETAILS ==> CST_ITEM_CST_DTLS_INTERFACE
776: */
777:
778: location := 6;
779:

Line 780: INSERT INTO CST_ITEM_CST_DTLS_INTERFACE (

776: */
777:
778: location := 6;
779:
780: INSERT INTO CST_ITEM_CST_DTLS_INTERFACE (
781: GROUP_ID,
782: INVENTORY_ITEM_ID,
783: ORGANIZATION_ID,
784: COST_TYPE_ID,

Line 1000: FROM cst_item_cst_dtls_interface cicdi, cst_uom_conv_rates_temp cucr

996: SELECT USAGE_RATE_OR_AMOUNT,
997: ITEM_COST,
998: YIELDED_COST, /*Added for bug 14159528*/
999: uom_conversion_rate
1000: FROM cst_item_cst_dtls_interface cicdi, cst_uom_conv_rates_temp cucr
1001: WHERE cicdi.inventory_item_id = cucr.inventory_item_id
1002: AND cicdi.basis_type = 1
1003: AND cicdi.group_id = grp_id)
1004: SET USAGE_RATE_OR_AMOUNT = USAGE_RATE_OR_AMOUNT / uom_conversion_rate,

Line 1019: FROM cst_item_cst_dtls_interface cicdi, cst_uom_conv_rates_temp cucr

1015: SELECT BASIS_FACTOR,
1016: ITEM_COST,
1017: YIELDED_COST, /*Added for bug 14159528*/
1018: uom_conversion_rate
1019: FROM cst_item_cst_dtls_interface cicdi, cst_uom_conv_rates_temp cucr
1020: WHERE cicdi.inventory_item_id = cucr.inventory_item_id
1021: AND cicdi.basis_type <> 1
1022: AND cicdi.group_id = grp_id)
1023: SET BASIS_FACTOR = BASIS_FACTOR / uom_conversion_rate,