DBA Data[Home] [Help]

APPS.WMS_SHIPPING_TRANSACTION_PUB dependencies on WSH_SHIP_CONFIRM_RULES

Line 3709: wsh_ship_confirm_rules wscr

3705: CURSOR ship_confirm_parameters IS
3706: SELECT wsp.ship_confirm_rule_id, wscr.stage_del_flag,
3707: wscr.ac_intransit_flag, wscr.ac_close_trip_flag, wscr.ac_defer_interface_flag
3708: FROM wsh_shipping_parameters wsp,
3709: wsh_ship_confirm_rules wscr
3710: WHERE wsp.organization_id = p_organization_id
3711: AND wscr.ship_confirm_rule_id = wsp.ship_confirm_rule_id;
3712:
3713: BEGIN

Line 4116: FROM wsh_shipping_parameters wsp, wsh_ship_confirm_rules wscr

4112: AND ROWNUM = 1;
4113:
4114: CURSOR C_Ship_Confirm_Parameters IS
4115: SELECT wsp.ship_confirm_rule_id, wscr.ac_intransit_flag, wscr.ac_close_trip_flag, wscr.ac_defer_interface_flag
4116: FROM wsh_shipping_parameters wsp, wsh_ship_confirm_rules wscr
4117: WHERE wsp.organization_id = p_organization_id
4118: AND wscr.ship_confirm_rule_id = wsp.ship_confirm_rule_id;
4119:
4120: CURSOR Check_Last_Trip (l_delivery_id NUMBER) IS