DBA Data[Home] [Help]

APPS.CSTPLCAC dependencies on WIP_DISCRETE_JOBS

Line 104: FROM wip_discrete_jobs wdj

100: ----------------------------------------------*/
101: l_stmt_num := 20;
102: SELECT wdj.start_quantity
103: INTO l_lot_size
104: FROM wip_discrete_jobs wdj
105: WHERE wdj.wip_entity_id = i_wip_entity_id
106: AND wdj.organization_id = i_org_id;
107:
108: /*----------------------------------------------

Line 143: wip_discrete_jobs wdj

139: l_comp_cost_source,
140: l_c_cost_type_id
141: from
142: wip_accounting_classes wac,
143: wip_discrete_jobs wdj
144: where
145: wdj.wip_entity_id = i_wip_entity_id and
146: wdj.organization_id = i_org_id and
147: wdj.class_code = wac.class_code and

Line 192: WIP_DISCRETE_JOBS

188: 1 )
189: into
190: l_use_val_cost_type
191: from
192: WIP_DISCRETE_JOBS
193: WHERE
194: WIP_ENTITY_ID = i_wip_entity_id AND
195: ORGANIZATION_ID = i_org_id;
196:

Line 1254: wip_discrete_jobs wdj

1250: l_comp_cost_source,
1251: l_c_cost_type_id
1252: from
1253: wip_accounting_classes wac,
1254: wip_discrete_jobs wdj
1255: where
1256: wdj.wip_entity_id = i_wip_entity_id and
1257: wdj.organization_id = i_org_id and
1258: wdj.class_code = wac.class_code and

Line 1303: WIP_DISCRETE_JOBS

1299: 1 )
1300: into
1301: l_use_val_cost_type
1302: from
1303: WIP_DISCRETE_JOBS
1304: WHERE
1305: WIP_ENTITY_ID = i_wip_entity_id AND
1306: ORGANIZATION_ID = i_org_id;
1307:

Line 1425: FROM wip_discrete_jobs wdj

1421: ----------------------------------------------*/
1422:
1423: SELECT wdj.start_quantity
1424: INTO l_lot_size
1425: FROM wip_discrete_jobs wdj
1426: WHERE wdj.wip_entity_id = i_wip_entity_id
1427: AND wdj.organization_id = i_org_id;
1428:
1429: /*----------------------------------------------