DBA Data[Home] [Help]

APPS.GMF_CBOM_REP_PKG dependencies on CM_CMPT_DTL

Line 58: FROM cm_cmpt_dtl

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
59: WHERE inventory_item_id = p_prod_invy_item_id
60: AND period_id = p_period_id
61: AND cost_type_id = p_cost_type_id
62: AND organization_id = p_organization_id

Line 71: AND cmpntcost_id in (select cmpntcost_id from cm_cmpt_dtl

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
72: WHERE inventory_item_id = p_prod_invy_item_id
73: AND period_id = p_period_id
74: AND cost_type_id = p_cost_type_id
75: AND organization_id = p_organization_id