APPS.WMS_RFID_DEVICE_PUB dependencies on WMS_SHIPPING_TRANSACTION_TEMP

Line 569: from WMS_SHIPPING_TRANSACTION_TEMP

565: IS
566:
567: cursor delivery_for_trip is
568: select distinct delivery_id
569: from WMS_SHIPPING_TRANSACTION_TEMP
570: where organization_id = p_organization_id
571: and dock_door_id = p_dock_door_id
572: and trip_id = p_trip_id;
573:

Line 576: from WMS_SHIPPING_TRANSACTION_TEMP

572: and trip_id = p_trip_id;
573:
574: cursor delivery_for_dock is
575: select distinct delivery_id
576: from WMS_SHIPPING_TRANSACTION_TEMP
577: where organization_id = p_organization_id
578: and dock_door_id = p_dock_door_id
579: and dock_appoint_flag = 'N';
580:

Line 689: from WMS_SHIPPING_TRANSACTION_TEMP

685: BEGIN
686: if p_trip_id >0 then
687: select 1
688: into temp_val
689: from WMS_SHIPPING_TRANSACTION_TEMP
690: where organization_id = p_organization_id
691: and dock_door_id = p_dock_door_id
692: and trip_id = p_trip_id
693: and rownum = 1

Line 698: from WMS_SHIPPING_TRANSACTION_TEMP

694: for update NOWAIT;
695: else
696: select 1
697: into temp_val
698: from WMS_SHIPPING_TRANSACTION_TEMP
699: where organization_id = p_organization_id
700: and dock_door_id = p_dock_door_id
701: and dock_appoint_flag = 'N'
702: and rownum = 1

Line 743: from WMS_SHIPPING_TRANSACTION_TEMP

739: x_deli_count := 0;
740: if p_trip_id >0 then
741: select count(distinct delivery_id)
742: into x_deli_count
743: from WMS_SHIPPING_TRANSACTION_TEMP
744: where organization_id = p_organization_id
745: and dock_door_id = p_dock_door_id
746: and trip_id = p_trip_id;
747: else

Line 750: from WMS_SHIPPING_TRANSACTION_TEMP

746: and trip_id = p_trip_id;
747: else
748: select count(distinct delivery_id)
749: into x_deli_count
750: from WMS_SHIPPING_TRANSACTION_TEMP
751: where organization_id = p_organization_id
752: and dock_door_id = p_dock_door_id
753: and dock_appoint_flag = 'N';
754: end if;