DBA Data[Home] [Help]

APPS.CSTPLCAC dependencies on WIP_PARAMETERS

Line 51: in WIP Parameters.*/

47: Added decode to WRO.qpa to get proportioned qpa in
48: case of Lot Based Materials
49: Divide the value of quantity per assembly by component
50: yield factor if Include Component Yield Flag is checked
51: in WIP Parameters.*/
52: cursor wro_cursor is
53: select WRO.operation_seq_num,
54: WRO.inventory_item_id,
55: Decode(WRO.basis_type, 2, WRO.quantity_per_assembly/l_lot_size,

Line 116: FROM wip_parameters

112: ------------------------------------------------*/
113: l_stmt_num := 25;
114: SELECT nvl(include_component_yield, 1)
115: INTO l_include_comp_yield
116: FROM wip_parameters
117: WHERE organization_id = i_org_id;
118:
119: -----------------------------------------
120: -- retrieve information for determining

Line 1164: in WIP Parameters.*/

1160: Added decode to WRO.qpa to get proportioned qpa in
1161: case of Lot Based Materials
1162: Divide the value of quantity per assembly by component
1163: yield factor if Include Component Yield Flag is checked
1164: in WIP Parameters.*/
1165:
1166: /* Begin Bug 4246122 */
1167: l_use_val_cost_type NUMBER;
1168: l_wip_entity_type NUMBER;

Line 1436: FROM wip_parameters

1432: component yield factor in quantity per assembly
1433: ------------------------------------------------*/
1434: SELECT nvl(include_component_yield, 1)
1435: INTO l_include_comp_yield
1436: FROM wip_parameters
1437: WHERE organization_id = i_org_id;
1438:
1439: ---------------------------------------------
1440: -- Replenish component material quantities