APPS.WSMPVLDT dependencies on WSM_PARAMETERS

Line 846: | Default coproducts_supply from wsm_parameters if |

842: END LOOP;
843:
844:
845: /*-----------------------------------------------------------------+
846: | Default coproducts_supply from wsm_parameters if |
847: | it is null in wsm_resulting_jobs_interface |
848: +-----------------------------------------------------------------*/
849:
850:

Line 859: FROM wsm_parameters

855: UPDATE wsm_resulting_jobs_interface wrji
856: SET wrji.coproducts_supply =
857: (SELECT decode(coproducts_supply_default, NULL, 2
858: , coproducts_supply_default)
859: FROM wsm_parameters
860: WHERE organization_id = c_coproducts_supply_rec.org_id )
861: WHERE wrji.header_id = c_coproducts_supply_rec.header_id
862: AND ( wrji.coproducts_supply is NULL OR
863: wrji.coproducts_supply NOT IN (1,2));

Line 1615: from wsm_parameters para

1611: Begin
1612: l_stmt_num := 5;
1613:
1614: select null into l_dummy
1615: from wsm_parameters para
1616: where para.organization_id = l_cur_wsmti_rec.organization_id
1617: and exists ( select null
1618: from mtl_parameters mtl
1619: where mtl.organization_id = para.organization_id)