DBA Data[Home] [Help]

APPS.WIP_BIS_PERIOD_BAL_PKG dependencies on ORG_ACCT_PERIODS

Line 64: ORG_ACCT_PERIODS OAP2 ,

60: + NVL(WPB.TL_OUTSIDE_PROCESSING_VAR,0)+ NVL(WPB.PL_MATERIAL_VAR,0)+NVL(WPB.PL_RESOURCE_VAR,0)
61: + NVL(WPB.PL_OVERHEAD_VAR,0)+NVL(WPB.PL_OUTSIDE_PROCESSING_VAR,0)+ NVL(WPB.TL_MATERIAL_OVERHEAD_VAR,0)
62: + NVL(WPB.PL_MATERIAL_OVERHEAD_VAR,0)))
63: FROM
64: ORG_ACCT_PERIODS OAP2 ,
65: ORG_ORGANIZATION_DEFINITIONS OOD ,
66: WIP_DISCRETE_JOBS WDJ ,
67: WIP_PERIOD_BALANCES WPB ,
68: ORG_ACCT_PERIODS OAP ,

Line 68: ORG_ACCT_PERIODS OAP ,

64: ORG_ACCT_PERIODS OAP2 ,
65: ORG_ORGANIZATION_DEFINITIONS OOD ,
66: WIP_DISCRETE_JOBS WDJ ,
67: WIP_PERIOD_BALANCES WPB ,
68: ORG_ACCT_PERIODS OAP ,
69: MTL_CATEGORIES_KFV MCKFV ,
70: MTL_ITEM_CATEGORIES MIC ,
71: MTL_DEFAULT_CATEGORY_SETS MDCS
72: WHERE

Line 117: ORG_ACCT_PERIODS OAP2 ,

113: + NVL(WPB.TL_OUTSIDE_PROCESSING_VAR,0)+ NVL(WPB.PL_MATERIAL_VAR,0)+NVL(WPB.PL_RESOURCE_VAR,0)
114: + NVL(WPB.PL_OVERHEAD_VAR,0)+ NVL(WPB.PL_OUTSIDE_PROCESSING_VAR,0)+ NVL(WPB.TL_MATERIAL_OVERHEAD_VAR,0)
115: + NVL(WPB.PL_MATERIAL_OVERHEAD_VAR,0)) )
116: FROM
117: ORG_ACCT_PERIODS OAP2 ,
118: ORG_ORGANIZATION_DEFINITIONS OOD ,
119: WIP_REPETITIVE_SCHEDULES WRS ,
120: WIP_REPETITIVE_ITEMS WRI ,
121: WIP_PERIOD_BALANCES WPB ,

Line 122: ORG_ACCT_PERIODS OAP ,

118: ORG_ORGANIZATION_DEFINITIONS OOD ,
119: WIP_REPETITIVE_SCHEDULES WRS ,
120: WIP_REPETITIVE_ITEMS WRI ,
121: WIP_PERIOD_BALANCES WPB ,
122: ORG_ACCT_PERIODS OAP ,
123: MTL_CATEGORIES_KFV MCKFV ,
124: MTL_ITEM_CATEGORIES MIC , MTL_DEFAULT_CATEGORY_SETS MDCS
125: WHERE
126: WRI.ORGANIZATION_ID = OOD.ORGANIZATION_ID