DBA Data[Home] [Help]

APPS.GMF_CBOM_REP_PKG dependencies on CM_SCST_LED

Line 54: FROM cm_scst_led

50:
51: IF (p_prod_ingr_ind = 'P') THEN
52: --SELECT std_qty, form_prod_uom into l_quantity, l_uom
53: SELECT product_qty, form_prod_uom into l_quantity, l_uom
54: FROM cm_scst_led
55: WHERE std_qty > 0
56: AND rownum < 2
57: AND cmpntcost_id in (SELECT cmpntcost_id
58: FROM cm_cmpt_dtl

Line 67: FROM cm_scst_led

63: ) ;
64:
65: ELSIF ((p_prod_ingr_ind = 'I') OR (p_prod_ingr_ind = 'B')) THEN
66: SELECT item_fmqty, item_fmqty_uom INTO l_quantity, l_uom
67: FROM cm_scst_led
68: WHERE inventory_item_id = p_invy_item_id
69: AND rownum < 2
70: AND (line_type = -1 OR line_type = 2)
71: AND cmpntcost_id in (select cmpntcost_id from cm_cmpt_dtl