APPS.CSTPCOIC dependencies on CST_ITEM_CST_DTLS_INTERFACE

Line 760: * Copy over columns into CST_ITEM_CST_DTLS_INTERFACE

756: RETURN( 1 );
757: END IF;
758:
759: /*
760: * Copy over columns into CST_ITEM_CST_DTLS_INTERFACE
761: * from CST_ITEM_COST_DETAILS
762: *
763: * CST_ITEM_COST_DETAILS ==> CST_ITEM_CST_DTLS_INTERFACE
764: */

Line 763: * CST_ITEM_COST_DETAILS ==> CST_ITEM_CST_DTLS_INTERFACE

759: /*
760: * Copy over columns into CST_ITEM_CST_DTLS_INTERFACE
761: * from CST_ITEM_COST_DETAILS
762: *
763: * CST_ITEM_COST_DETAILS ==> CST_ITEM_CST_DTLS_INTERFACE
764: */
765:
766: location := 6;
767:

Line 768: INSERT INTO CST_ITEM_CST_DTLS_INTERFACE (

764: */
765:
766: location := 6;
767:
768: INSERT INTO CST_ITEM_CST_DTLS_INTERFACE (
769: GROUP_ID,
770: INVENTORY_ITEM_ID,
771: ORGANIZATION_ID,
772: COST_TYPE_ID,

Line 987: FROM cst_item_cst_dtls_interface cicdi, cst_uom_conv_rates_temp cucr

983: UPDATE (
984: SELECT USAGE_RATE_OR_AMOUNT,
985: ITEM_COST,
986: uom_conversion_rate
987: FROM cst_item_cst_dtls_interface cicdi, cst_uom_conv_rates_temp cucr
988: WHERE cicdi.inventory_item_id = cucr.inventory_item_id
989: AND cicdi.basis_type = 1
990: AND cicdi.group_id = grp_id)
991: SET USAGE_RATE_OR_AMOUNT = USAGE_RATE_OR_AMOUNT / uom_conversion_rate,

Line 1004: FROM cst_item_cst_dtls_interface cicdi, cst_uom_conv_rates_temp cucr

1000: UPDATE (
1001: SELECT BASIS_FACTOR,
1002: ITEM_COST,
1003: uom_conversion_rate
1004: FROM cst_item_cst_dtls_interface cicdi, cst_uom_conv_rates_temp cucr
1005: WHERE cicdi.inventory_item_id = cucr.inventory_item_id
1006: AND cicdi.basis_type <> 1
1007: AND cicdi.group_id = grp_id)
1008: SET BASIS_FACTOR = BASIS_FACTOR / uom_conversion_rate,