DBA Data[Home] [Help]

APPS.GMD_QMSMC dependencies on GME_BATCH_HEADER

Line 2051: -- Bug 4165704: 1. a.wip_subinventory taken out since it no longer exists in gme_batch_header

2047:
2048:
2049:
2050: /* This cursor works for both batch created and batchstep created event */
2051: -- Bug 4165704: 1. a.wip_subinventory taken out since it no longer exists in gme_batch_header
2052: -- 2. a.revision added
2053: CURSOR C1(x_batch_id varchar2,x_batch_step_id varchar2) is
2054: SELECT A.BATCH_NO,
2055: A.BATCH_ID,

Line 2076: FROM GME_BATCH_HEADER A,

2072: H.FORMULA_NO||' / '||FORMULA_VERS,
2073: I.CONCATENATED_SEGMENTS ,
2074: I.DESCRIPTION ITEM_DESC1,
2075: A.LAST_UPDATED_BY
2076: FROM GME_BATCH_HEADER A,
2077: GMD_RECIPE_VALIDITY_RULES b,
2078: GMD_RECIPES_B C, --GMD_RECIPES C performance bug# 4916912
2079: GME_MATERIAL_DETAILS F,
2080: FM_FORM_MST_B H, --FM_FORM_MST H performance bug# 4916912

Line 2119: FROM GME_BATCH_HEADER A,

2115: H.FORMULA_NO||' / '||FORMULA_VERS,
2116: I.CONCATENATED_SEGMENTS ITEM_NUMBER ,
2117: I.DESCRIPTION,
2118: A.LAST_UPDATED_BY
2119: FROM GME_BATCH_HEADER A,
2120: GMD_RECIPE_VALIDITY_RULES b,
2121: GMD_RECIPES_B C, --GMD_RECIPES C performance bug# 4916912
2122: GME_BATCH_STEPS D,
2123: GME_MATERIAL_DETAILS F,